Question: Help me fill out the analysis chart and the answer the last question The secret is out! Your catering has been such a hit that

Help me fill out the analysis chart and the answer the last question

The secret is out! Your catering has been such a hit that you finally opened a small bakery just around the corner. You no longer track costs by job. You have switched to a process costing system. You have three different major processes: mixing, baking, and packaging. Because your business is booming, you purchase ingredients in bulk which has reduced the cost but the new brick-and-mortar store has increased fixed costs. Perform an analysis on the bakery's performance and draft recommendations for making it better. Pay special attention to the "Assumptions" section.

Assumptions:
1. Inventory cost flow is average cost
2. There are no unfinished units (work in process)
3. Direct labor: Baker (your paycheck)
3a. Baker (your paycheck) - decorate and package $20.00 hour
You decorate and package 8 dozen cupcakes per hour for 6 hours a day
3b. Apprentice (mixes & bakes) $15.00 hour
The apprentice mixes and bakes 6 dozen cupcakes per hour and works 8 hours a day
4. Predetermined overhead rate $2.50 dozen
5. The bakery PRODUCED the following units
Vanilla cupcakes w/ vanilla icing 30 dozen
Vanilla cupcakes w/ chocolate icing 24 dozen
Chocolate cupcakes w/ chocolate icing 50 dozen
Chocolate cupcakes w/ vanilla icing 15 dozen
6. The bakery SOLD the following units
Vanilla cupcakes w/ vanilla icing 29 dozen
Vanilla cupcakes w/ chocolate icing 20 dozen
Chocolate cupcakes w/ chocolate icing 45 dozen
Chocolate cupcakes w/ vanilla icing 12 dozen
Price Per Dozen $17.00 dozen

Analysis
1. Calculate the average cost per unit.
2. Calculate the Cost of Goods PRODUCED for all products
3. Calculate the Cost of Goods SOLD and the profit or loss for all products
Vanilla cupcakes w/ vanilla icing Vanilla cupcakes w/ chocolate icing
Material Total Cost Material Total Cost
Flour Flour
Butter Butter
Sugar Sugar
Eggs Eggs
Milk Milk
Vanilla Vanilla
Vanilla Icing Chocolate icing
Bakery Box Bakery Box
Labor: Baker Labor: Baker
Labor: Apprent Labor: Apprent
Overhead Overhead
Total Cost Total Cost
Customer Price Customer Price
Total Profit/Loss Total Profit/Loss
Chocolate cupcakes w/ chocolate icing Chocolate cupcakes w/ vanilla icing
Material Total Cost Material Total Cost
Flour Flour
Butter Butter
Sugar Sugar
Eggs Eggs
Milk Milk
Cocoa Powder Cocoa Powder
Chocolate icing Vanilla Icing
Bakery Box Bakery Box
Labor: Baker Labor: Baker
Labor: Apprent Labor: Apprent
Overhead Overhead
Total Cost Total Cost
Customer Price Customer Price
Total Profit/Loss Total Profit/Loss

Evaluate the profitability of each cupcake category. Recommend ways to optimize operations. Operations include controlling cost and inventories, improving efficiency, etc.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!