Question

In: Accounting

ACC 650 - Managerial Accounting Process Costing Revised Problem 4-29 Moravia Company processes and packages cream...

ACC 650 - Managerial Accounting

Process Costing

Revised Problem 4-29

Moravia Company processes and packages cream cheese. The following data have been compiled for the month of June. Conversion activity occurs uniformly throughout the production process.

Work in process, June 1 - 60,000 units:
Direct material: 100% complete cost of 110,000
Conversion: 30% complete, cost of 43,000
Balance in work in progress, June 1 153,000
Units started during June 180,000
Units completed during June and transferred out to finished-goods inventory 210,000
Work in process, June 30:
Direct material: 100% complete
Conversion: 80% complete
Costs Incurred During June:
Direct Material 420,000
Conversion Costs:
Direct Labor 93,250
Applied Manufacturing Overhead 283,400
Total Conversion Costs 376,650

Required: Prepare schedules to accomplish each of the following process-costing steps for the month of June. Use the weighted-average method of process costing.

1. Analysis of physical flow of units.

2. Calculation of equivalent units.

3. Computation of units costs.

4. Analysis of total costs.

5. Construct an Excel spreadsheet and show all of the preceding requirements

Show how the solution would change if the following data change: June 1 work-in-process costs were $84,000 for direct material and $26,000 for conversion.

PLEASE SHOW THE WORK

Solutions

Expert Solution

1)

Units to account for
Work in process-Beginning inventory 60000
Units started during the period 180000
Total units to account for 240000
Units accounted for
completed and transferred out 210000
Work in process -ending inventory (balancing figure) 30000
Total units accounted for 240000

2)

Material conversion
Units completed and transferred out 210000 210000
Ending work in process inventory 30000*100%=30000 30000*80%=24000
Equivalent unit of production 240000 234000

3)

Material conversion
Beginning work in process cost 110000 43000
current period cost 420000 376650
Total cost of work in process [A] 530000 419650
Equivalent unit of production [B] 240000 234000
unit cost [A/B] 2.20833 1.79338

4)

Cost to account for Material conversion Total
Beginning work in process 110000 43000 153000
current period cost 420000 376650 796650
Total cost to account for 530000 419650 949650
cost accounted for
completed and transferred out (equivalent unit *unit cost) 210000*2.20833= 463749 210000*1.79338= 376610 840359
Ending work in process 30000*2.20833= 66250 24000*1.79338= 43041 109291
Total cost accounted for 529999 (approx to 530000) 419651 (approx to 419650) 949650

#The difference in total cost accounted for amounting to $ 1 is due to decimal places in unit cost


Related Solutions

Revised Problem 4-29 Moravia Company processes and packages cream cheese. The following data have been compiled...
Revised Problem 4-29 Moravia Company processes and packages cream cheese. The following data have been compiled for the month of June. Conversion activity occurs uniformly throughout the production process. Work in process, June 1 - 60,000 units: Direct material: 100% complete cost of 110,000 Conversion: 30% complete, cost of 43,000 Balance in work in process, June 1 153,000 Units started during June 180,000 Units completed during June and transferred out to finished-goods inventory 210,000 Work in process, June 30: Direct...
#4 REVISED PROBLEM 13-42 ACC 650 - Management Accounting Megatronics Corporation, a massive retailer of electronic...
#4 REVISED PROBLEM 13-42 ACC 650 - Management Accounting Megatronics Corporation, a massive retailer of electronic products, is organized in four separate divisions. The four divisional managers are evaluated at year-end, and bonuses are awarded based on ROI. Last year, the company as a whole produced a 13 percent return on its investment. During the past week, management of the company’s Northeast Division was approached about the possibility of buying a competitor that had decided to redirect its retail activities....
#3 REVISED PROBLEM 13-42 ACC 650 - Management Accounting Megatronics Corporation, a massive retailer of electronic...
#3 REVISED PROBLEM 13-42 ACC 650 - Management Accounting Megatronics Corporation, a massive retailer of electronic products, is organized in four separate divisions. The four divisional managers are evaluated at year-end, and bonuses are awarded based on ROI. Last year, the company as a whole produced a 13 percent return on its investment. During the past week, management of the company’s Northeast Division was approached about the possibility of buying a competitor that had decided to redirect its retail activities....
#2 REVISED PROBLEM 13-42 ACC 650 - Management Accounting Megatronics Corporation, a massive retailer of electronic...
#2 REVISED PROBLEM 13-42 ACC 650 - Management Accounting Megatronics Corporation, a massive retailer of electronic products, is organized in four separate divisions. The four divisional managers are evaluated at year-end, and bonuses are awarded based on ROI. Last year, the company as a whole produced a 13 percent return on its investment. During the past week, management of the company’s Northeast Division was approached about the possibility of buying a competitor that had decided to redirect its retail activities....
#5 REVISED PROBLEM 13-42 ACC 650 - Management Accounting Megatronics Corporation, a massive retailer of electronic...
#5 REVISED PROBLEM 13-42 ACC 650 - Management Accounting Megatronics Corporation, a massive retailer of electronic products, is organized in four separate divisions. The four divisional managers are evaluated at year-end, and bonuses are awarded based on ROI. Last year, the company as a whole produced a 13 percent return on its investment. During the past week, management of the company’s Northeast Division was approached about the possibility of buying a competitor that had decided to redirect its retail activities....
ACC 650 - REVISED PROBLEM 17-26 - QUESTION #1 Celestial Artistry Company is developing departmental overhead...
ACC 650 - REVISED PROBLEM 17-26 - QUESTION #1 Celestial Artistry Company is developing departmental overhead rates based on direct-labor hours    for its two production departments, Finishing and Etching. The Finishing Department employs        120 people and the Etching Department employs 60 people. Each person in these two departments    works 1,500 hours per year. The production-related overhead costs for the Finishing Department are    budgeted at $330,000, and the Etching Department costs are budgeted at $280,000. Two...
ACC 650 - REVISED PROBLEM 17-26 - QUESTION #2 Celestial Artistry Company is developing departmental overhead...
ACC 650 - REVISED PROBLEM 17-26 - QUESTION #2 Celestial Artistry Company is developing departmental overhead rates based on direct-labor hours    for its two production departments, Finishing and Etching. The Finishing Department employs        120 people and the Etching Department employs 60 people. Each person in these two departments    works 1,500 hours per year. The production-related overhead costs for the Finishing Department are    budgeted at $330,000, and the Etching Department costs are budgeted at $280,000. Two...
ACC 650 - REVISED PROBLEM 7-38 - (Required 3) ■ Problem 7–38 Sales Mix and Employee...
ACC 650 - REVISED PROBLEM 7-38 - (Required 3) ■ Problem 7–38 Sales Mix and Employee Compensation; Operating Changes (LO 7-4, 7-5) 2(c). Commissions, total: $535,600 Lawrence Corporation sells two ceiling fans, Deluxe and Basic. Current sales total 66,000 units, consisting of 44,000 Deluxe units and 22,000 Basic units. Selling price and variable cost information follow. Deluxe Basic Selling Price $92 $76 Variable Cost 64 38 Salespeople currently receive flat salaries that total $350,000. Management is contemplating a change to...
ACC 650 - REVISED PROBLEM 14-47 #4 Tipton One-Stop Decorating sells paint and paint supplies, carpet,...
ACC 650 - REVISED PROBLEM 14-47 #4 Tipton One-Stop Decorating sells paint and paint supplies, carpet, and wallpaper at a single-store location in suburban Des Moines. Although the company has been very profitable over the years, management has seen a significant decline in wallpaper sales and earnings. Much of this decline is attributable to the Internet and to companies that advertise deeply discounted prices in magazines and offer customers free shipping and toll-free telephone numbers. Recent figures follow. Paint and...
ACC 650 - REVISED PROBLEM 14-47 #3 Tipton One-Stop Decorating sells paint and paint supplies, carpet,...
ACC 650 - REVISED PROBLEM 14-47 #3 Tipton One-Stop Decorating sells paint and paint supplies, carpet, and wallpaper at a single-store location in suburban Des Moines. Although the company has been very profitable over the years, management has seen a significant decline in wallpaper sales and earnings. Much of this decline is attributable to the Internet and to companies that advertise deeply discounted prices in magazines and offer customers free shipping and toll-free telephone numbers. Recent figures follow. Paint and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT