The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 402 Weeks Ago, 5 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Problem 10-26 Flexible Budget and Overhead Performance Report [LO4, LO5, LO6, LO7]
|
Groschl Company has had great difficulty in controlling manufacturing overhead costs. At a recent convention, the president heard about a control device for overhead costs known as a flexible budget, and he has hired you to implement this budgeting program in Groschl Company. After some effort, you have developed the following cost formulas for the companyAc€?cs Machining Department. These costs are based on a normal operating range of 12,200 to 24,400 machine-hours per month: |
  Â
| Â Â Overhead Cost | Cost Formula |
| Â Â Utilities | $1.05 per machine-hour |
| Â Â Lubricants | $1.49 per machine-hour plus $9,300 per month |
| Â Â Machine setup | $0.49 per machine-hour |
| Â Â Indirect labour | $0.87 per machine-hour plus $172,000 per month |
| Â Â Depreciation | $50,500 per month |
| Â | |
 Â
|
     During March, the first month after your preparation of the above data, the Machining Department worked 22,000 machine-hours and produced 11,000 units of product. The actual manufacturing overhead costs for March were as follows: |
 Â
| Â | Â | Â |
| Â Â Utilities | $ | 22,140 |
| Â Â Lubricants | Â | 40,100 |
| Â Â Machine setup | Â | 12,690 |
| Â Â Indirect labour | Â | 193,210 |
| Â Â Depreciation | Â | 50,500 |
| Â Â | Â | Â |
| Â Â Total manufacturing overhead cost | $ | 318,640 |
| Â | Â | Â |
| Â | ||
 Â
| Fixed costs had no budget variances. The department had originally been budgeted to work 24,400 machine-hours during March. |
 Â
| Required: |
| 1. |
Prepare an overhead performance report for the Machining Department for the month of March.(Indicate the effect of each variance by selecting "F" for favourable, "U" for unfavourable, and "None" for no effect (i.e., zero variance). Leave no cells blank - be certain to enter "0" wherever required. Input all amounts as positive values. Round your cost formula answers to 2 decimal places. Omit the "$" sign in your response.) |
 Â
| The Groschi Company | |||||
| Overhead Performance ReportAc€??Machining Department | |||||
| For the Month of March | |||||
| Â Â | |||||
| Overhead Costs | Cost Formula per MH |
Actual 22,000 MHs |
Flexible Budget 22,000 MHs | Spending Variance | |
| Â Â Variable: | Â | Â | Â | Â | Â |
|     Utilities | $   | $   | $    | $  | (Click to select)UFNone  |
| Â Â Â Â Lubricants | Â Â | Â Â | Â Â Â | Â Â | (Click to select)NoneFUÂ Â |
|     Machine setup |   |   |    |   | (Click to select)UFNone  |
| Â Â Â Â Indirect labour | Â Â | Â Â | Â Â Â | Â Â | (Click to select)NoneFUÂ Â |
| Â | Â | Â | Â | Â | Â |
| Â Â Total variable cost | $Â Â Â | Â Â | Â Â Â | Â Â | (Click to select)NoneUFÂ Â |
| Â | Â | Â | Â | Â | Â |
| Â Â Fixed: | Â | Â | Â | Â | Â |
| Â Â Â Â Lubricants | Â | Â Â | Â Â Â | Â Â | (Click to select)NoneFUÂ Â |
| Â Â Â Â Indirect labour | Â | Â Â | Â Â Â | Â Â | (Click to select)UNoneFÂ Â |
| Â Â Â Â Depreciation | Â | Â Â | Â Â Â | Â Â | (Click to select)UNoneFÂ Â |
| Â Â | Â | Â | Â | Â | Â |
|   Total fixed cost |  |   |    |   | (Click to select)FUNone  |
| Â | Â | Â | Â | Â | Â |
| Â Â Total overhead cost | Â | $Â Â Â | $Â Â Â Â | $Â Â | (Click to select)UNoneFÂ Â |
Â
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll