The accounting problem below must be completed using a PC spreadsheet program such as Microsoft Excel. A printout of the solution is to be submitted along with a copy of the spreadsheet with formulas.
Thread Company is preparing its manufacturing overhead budget for 2012. Relevant data consist of the following.
- Units to be produced (by quarters): 10,000, 12,000, 14,000, 16,000.
- Direct labor: Time is 1 hour per unit.
- Variable overhead costs per direct labor hour: Indirect materials $0.90; indirect labor $1.20; and maintenance $0.50.
- Fixed overhead costs per quarter: Supervisory salaries $40,000; depreciation $16,000; and maintenance $12,000.
Instructions:
Prepare the manufacturing overhead budget for the year, showing quarterly data. Follow the format illustrated on page 1043 of your text, Accounting: Tools for Business Decision Making.
If somebody can please e-mail the spreadsheet to (e-mail address removed)
I would greatly appreciate it. I can't figure out how to do this so I'm hoping somebody here can do the problem and send me the spreadsheet so I can look over it and study it for an upcoming test.
Thanks guys
Thread Company is preparing its manufacturing overhead budget for 2012. Relevant data consist of the following.
- Units to be produced (by quarters): 10,000, 12,000, 14,000, 16,000.
- Direct labor: Time is 1 hour per unit.
- Variable overhead costs per direct labor hour: Indirect materials $0.90; indirect labor $1.20; and maintenance $0.50.
- Fixed overhead costs per quarter: Supervisory salaries $40,000; depreciation $16,000; and maintenance $12,000.
Instructions:
Prepare the manufacturing overhead budget for the year, showing quarterly data. Follow the format illustrated on page 1043 of your text, Accounting: Tools for Business Decision Making.
If somebody can please e-mail the spreadsheet to (e-mail address removed)
I would greatly appreciate it. I can't figure out how to do this so I'm hoping somebody here can do the problem and send me the spreadsheet so I can look over it and study it for an upcoming test.
Thanks guys