Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help answer question to problem 1 thru 3 and the Problem Analysis 1-3. Thank you so much! a. Computations for 8,500 Apple Pies 1.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Please help answer question to problem 1 thru 3 and the Problem Analysis 1-3. Thank you so much!

a. Computations for 8,500 Apple Pies 1. Variahle Manufarturinn Fenste ner unir 2 Nikki started by talking with her parents about some of the estimated sales and costs that they thought would incur for the month of September. Here are some of those estimates: Additionally, Sally informed her that the farm received a special order to sell their apple pies and caramel apples at the local county fair in September. Sally wanted to sell 3,500 pies and 4,500 caramel apples for a discounted price of $20.00 and $7.50, respectively. With, the number of staff and the size of the bakery, Nikki determined that the maximum capacity for the bakery is 4,200 labor hours a month. At the current projected sale amounts she expects that they'll need 3,550 hours to meet their regular sales volume. After review of the salaries of all the staff, Nikki determined that the average hourly wage was $16.00. Ned was also concerned about how much it cost to keep apple pie inventory on hand at the end of the month, caramel apples should be sold within a couple days, so no inventory is left at the end of the month. Since there is a limited shelf life for the apple pies, Ned and Sally try and keep the ending inventories in line with next month's expectations. They estimated that they'd have to start 10,000 apple pies in order to have 1,000 apple pies in-process at the end of the month and 500 finished pies. At the end of August there were 500 pies that were in-process and no finished pies. a. Labor hours required for special order b. Incremental profit/(loss) on special order If labor hours for the additional 8,000 units combined, then regular production will need to be reduced for the product with the lowest contribution marain c. Compute contribution margin per hour for regular orders Apple Hilly Farms a. Total Profit for the month of September b. Compute the weighted average contribution margin per unit Weights: Weighted-average contribution margin per unit c. Compute breakeven: Analysis for Problems 1 - 3 d. Compute contribution margin lost from regular sales e. Total contribution margin with special order Regular production contribution margin Difference in profit with special order The variable costs associated with these inventories were as follows: And the conversion cost for the in-process pies is 50% completed and 100% for direct materials. (Use the paragraph above to calculate the units completed and transferred out for work-in-process pies) September was a success for the bakery! They didn't complete the special order but focused on normal sales and with some overtime baked a few more pies. Here were the results for the actual sales and costs at the end of the month. (The actuals as presented below are only to be used for Problem 6.) Problems 1. For Apple Pies only, compute the variable manufacturing costs per unit, full unit cost per unit, variable cost per unit, full absorption cost per unit, prime cost per unit, conversion cost per unit, profit margin per unit, contribution margin per unit, and gross margin per unit. 2. Calculate the total profit expected for September, compute the weighted average contribution margin, and compute the breakeven in units. 3. Calculate the labor hours needed for the special order, calculate the incremental profit/(loss) for the special order, calculate the capacity available for regular orders, compute the contribution margin per hour for regular orders, compute the contribution margin lost from regular sales orders, calculate the total contribution margin including the special order. 4. Prepare the journal entries as given on the excel workbook. 5. Using the Weighted-Average method create the Production Cost Report for Apple Pies only, to include computing the total Apple Pies to be accounted for, computing the total Apple Pie costs to be accounted for, and calculating any necessary adjustments. 6. Create a Budget Analysis Report for the month of September, to include creating a Master Budget, and calculating the variance analyses between Actuals versus the Flexible Budget and versus the Master Budget. Note those variances as either being Favorable (F) or Unfavorable (U). Problem Analysis 1. What costs are excluded from the Gross Margin calculation? Why would we exclude these costs? 2. What does the mix of the weighted-average contribution margin tell us about the impact to profits of each product? 3. Should Apple Hilly Farms complete the Special Order? Explain your answer by using pricing terms from the textbook. 4. Was manufacturing overhead under or over applied? What does over or under applied overhead mean? 5. Why would Apple Hilly Farms use standard costing since actual costing gives the actual cost? Why would they not want to wait until the actual costs are known? 6. Explain the variances calculated for Apple Hilly Farms. Why was September a good or bad month for them? a. Computations for 8,500 Apple Pies 1. Variahle Manufarturinn Fenste ner unir 2 Nikki started by talking with her parents about some of the estimated sales and costs that they thought would incur for the month of September. Here are some of those estimates: Additionally, Sally informed her that the farm received a special order to sell their apple pies and caramel apples at the local county fair in September. Sally wanted to sell 3,500 pies and 4,500 caramel apples for a discounted price of $20.00 and $7.50, respectively. With, the number of staff and the size of the bakery, Nikki determined that the maximum capacity for the bakery is 4,200 labor hours a month. At the current projected sale amounts she expects that they'll need 3,550 hours to meet their regular sales volume. After review of the salaries of all the staff, Nikki determined that the average hourly wage was $16.00. Ned was also concerned about how much it cost to keep apple pie inventory on hand at the end of the month, caramel apples should be sold within a couple days, so no inventory is left at the end of the month. Since there is a limited shelf life for the apple pies, Ned and Sally try and keep the ending inventories in line with next month's expectations. They estimated that they'd have to start 10,000 apple pies in order to have 1,000 apple pies in-process at the end of the month and 500 finished pies. At the end of August there were 500 pies that were in-process and no finished pies. a. Labor hours required for special order b. Incremental profit/(loss) on special order If labor hours for the additional 8,000 units combined, then regular production will need to be reduced for the product with the lowest contribution marain c. Compute contribution margin per hour for regular orders Apple Hilly Farms a. Total Profit for the month of September b. Compute the weighted average contribution margin per unit Weights: Weighted-average contribution margin per unit c. Compute breakeven: Analysis for Problems 1 - 3 d. Compute contribution margin lost from regular sales e. Total contribution margin with special order Regular production contribution margin Difference in profit with special order The variable costs associated with these inventories were as follows: And the conversion cost for the in-process pies is 50% completed and 100% for direct materials. (Use the paragraph above to calculate the units completed and transferred out for work-in-process pies) September was a success for the bakery! They didn't complete the special order but focused on normal sales and with some overtime baked a few more pies. Here were the results for the actual sales and costs at the end of the month. (The actuals as presented below are only to be used for Problem 6.) Problems 1. For Apple Pies only, compute the variable manufacturing costs per unit, full unit cost per unit, variable cost per unit, full absorption cost per unit, prime cost per unit, conversion cost per unit, profit margin per unit, contribution margin per unit, and gross margin per unit. 2. Calculate the total profit expected for September, compute the weighted average contribution margin, and compute the breakeven in units. 3. Calculate the labor hours needed for the special order, calculate the incremental profit/(loss) for the special order, calculate the capacity available for regular orders, compute the contribution margin per hour for regular orders, compute the contribution margin lost from regular sales orders, calculate the total contribution margin including the special order. 4. Prepare the journal entries as given on the excel workbook. 5. Using the Weighted-Average method create the Production Cost Report for Apple Pies only, to include computing the total Apple Pies to be accounted for, computing the total Apple Pie costs to be accounted for, and calculating any necessary adjustments. 6. Create a Budget Analysis Report for the month of September, to include creating a Master Budget, and calculating the variance analyses between Actuals versus the Flexible Budget and versus the Master Budget. Note those variances as either being Favorable (F) or Unfavorable (U). Problem Analysis 1. What costs are excluded from the Gross Margin calculation? Why would we exclude these costs? 2. What does the mix of the weighted-average contribution margin tell us about the impact to profits of each product? 3. Should Apple Hilly Farms complete the Special Order? Explain your answer by using pricing terms from the textbook. 4. Was manufacturing overhead under or over applied? What does over or under applied overhead mean? 5. Why would Apple Hilly Farms use standard costing since actual costing gives the actual cost? Why would they not want to wait until the actual costs are known? 6. Explain the variances calculated for Apple Hilly Farms. Why was September a good or bad month for them

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Factory Business System Audit Lean Manufacturing

Authors: Rolf Thorsten

1st Edition

1091908583, 978-1091908581

More Books

Students also viewed these Accounting questions