This is a cost accounting project that will need a excel workbook to be complete

This is a cost accounting project that will need a excel workbook to be completed from information provided. part 1 You are the new cost accountant at SRS. In your new position, you have been asked to perform a few tasks for the company’s leadership team. Use the scenario info in the table below: “A: Create an overview diagram using whichever flowchart or diagram tool you feel most comfortable with. Paste it on the OVERVIEW DIAGRAM sheet. ” B: Prepare journal entries to summarize the 2017 transactions. As your final entry, dispose of the year-end under- or overallocated manufacturing overhead as a write-off to the Cost of Goods Sold (COGS) account. Assume COGS given of $4,020 does not include the write off of overallocated manufacturing overhead. Use the template on the JOURNAL ENTRIES sheet. “C: Show posted T-accounts for all inventories, Cost of Goods Sold, Manufacturing Overhead Control, and Manufacturing Overhead Allocated. Use the template on the T-ACCOUNTS sheet.” For the following, prepare a 1-2 page paper in a separate Word document. See Assignment Guidelines and Rubric document for detailed description D: How did the SRS Educational Press perform in 2017? Should the company continue to have in-house press production? Support your answer with relevant data (specific calculations regarding gross margin, what the numbers mean, justification, with research, for your recommendation) E: How did the SRS Educational Press perform in 2017? Should the company continue to have in-house press production? Support your answer with relevant data (specific calculations, what the numbers mean, research justification for your recommendation). part 2: In Final Project II, you will review the financial information provided for the four main departments of the organization: sales, purchasing, operations, and finance. Based on the information provided, you will create departmental budgets for each of the four departments. You will then create a master budget based on the department budgets. In addition, you will create an executive brief presentation regarding the budgeting process. You will also provide an overview of the department and master budgets.