Bakery, Inc. - 2 departments, two months Bakery, Inc. produces dessert cakes in two departments. Department 1 is Mixing and Baking and Department 2 is Tasting and Packaging. uses the Weighted Average Method of Process Cost Accounting. All material is added at the beginning of the process in the Mixing and Baking department and equally on a continuous basis in the Tasting and Packaging Department. The following information is available for the months of March and April, 20xx. There are 10 possible extra credit points; 5 points for May and 5 points for April. March Production Costs Mixing and Baking Dept. Tasting and Packaging Dept. 0 $18,279 Work in Process, Beginning of month Prior Department Costs Materials Labor Factory Overhead $5,416 $4,062 $2,708 $1,083 $541 $812 Costs incurred Current month Materials Labor Factory Overhead Total Costs $92,072 $67,700 $46,036 $59,576 $29,788 $44,602 March Production Report Mixing and Baking Department (Units) 1,354 6,770 2,708 Tasting and Packaging Department (Units) 677 ? 1,354 In Process, Beginning of month Units started and Transferred - In In Process, End of month Stage of completion - Ending Work in Process Materials Labor Overhead 100% 55% 40% 60% 45% 30% April Production Costs Mixing and Baking Dept. Tasting and Packaging Dept. Work in Process, Beginning of month Prior Department Costs Materials Labor Factory Overhead ? ? ? ? ? ? ? ? Costs incurred Current month Materials Labor Factory Overhead Total Costs You will need to provide any missing information $ 108,750 $74,675 49,300 $62,132 $34,220 $50,402 $101,210 ? ? C April Production Report Mixing and Baking Department (Units) ? 7,700 2,100 Tasting and Packaging Department (Units) ? ? 700 In Process, Beginning of month Units Started and Transferred-In In Process, End of month Stage of completion Materials Labor Overhead 80% 100% 75% 70% 70% 60% Required: . Using Excel, Prepare a Prepare a Cost of Production Report for the Mixing and Baking and Tasting and Packaging departments for March and April. Each department should be on a separate Excel Worksheet. You should end up with 4 worksheets. . . . Carry all computations of unit costs to 4 decimal places ($5.1234) Round all units to the nearest whole unit. Round total dollar amounts to the nearest cent (2 decimal places) Set your excel workbook to "Precision as Displayed" Set up a header on each worksheet which shows: Company Name, Tab Name and month. (centered) Put your name and current date in the upper right corner on each worksheet. Adjust the total cost of goods finished and transferred for any rounding error Please identify the amount of rounding error at the bottom of your cost of production summary. . . . . Bakery, Inc. - 2 departments, two months Bakery, Inc. produces dessert cakes in two departments. Department 1 is Mixing and Baking and Department 2 is Tasting and Packaging. uses the Weighted Average Method of Process Cost Accounting. All material is added at the beginning of the process in the Mixing and Baking department and equally on a continuous basis in the Tasting and Packaging Department. The following information is available for the months of March and April, 20xx. There are 10 possible extra credit points; 5 points for May and 5 points for April. March Production Costs Mixing and Baking Dept. Tasting and Packaging Dept. 0 $18,279 Work in Process, Beginning of month Prior Department Costs Materials Labor Factory Overhead $5,416 $4,062 $2,708 $1,083 $541 $812 Costs incurred Current month Materials Labor Factory Overhead Total Costs $92,072 $67,700 $46,036 $59,576 $29,788 $44,602 March Production Report Mixing and Baking Department (Units) 1,354 6,770 2,708 Tasting and Packaging Department (Units) 677 ? 1,354 In Process, Beginning of month Units started and Transferred - In In Process, End of month Stage of completion - Ending Work in Process Materials Labor Overhead 100% 55% 40% 60% 45% 30% April Production Costs Mixing and Baking Dept. Tasting and Packaging Dept. Work in Process, Beginning of month Prior Department Costs Materials Labor Factory Overhead ? ? ? ? ? ? ? ? Costs incurred Current month Materials Labor Factory Overhead Total Costs You will need to provide any missing information $ 108,750 $74,675 49,300 $62,132 $34,220 $50,402 $101,210 ? ? C April Production Report Mixing and Baking Department (Units) ? 7,700 2,100 Tasting and Packaging Department (Units) ? ? 700 In Process, Beginning of month Units Started and Transferred-In In Process, End of month Stage of completion Materials Labor Overhead 80% 100% 75% 70% 70% 60% Required: . Using Excel, Prepare a Prepare a Cost of Production Report for the Mixing and Baking and Tasting and Packaging departments for March and April. Each department should be on a separate Excel Worksheet. You should end up with 4 worksheets. . . . Carry all computations of unit costs to 4 decimal places ($5.1234) Round all units to the nearest whole unit. Round total dollar amounts to the nearest cent (2 decimal places) Set your excel workbook to "Precision as Displayed" Set up a header on each worksheet which shows: Company Name, Tab Name and month. (centered) Put your name and current date in the upper right corner on each worksheet. Adjust the total cost of goods finished and transferred for any rounding error Please identify the amount of rounding error at the bottom of your cost of production summary