Offered Price $45.00

BUSN6070 Waltham Motors Assignment

Question # 00613492
Subject: Education
Due on: 06/29/2020
Posted On: 06/29/2020 04:01 AM
Tutorials: 1
Posted By:
Feedback Score:

Purchase it
Report this Question as Inappropriate


Prepare a business case analysis for Waltham Motors including detailed answers to the following questions:

1.     List some facts that recently have occurred at Waltham Motors.

2.     Analyze the report that was presented by the accountant. Do you agree with his conclusions and recommendations?

3.     How can the cost control process be improved?

4.     Prepare a flexible budget, estimate the line by line variances and submit in excel. How does this result compare with the report presented in question #2?

5.     Prepare a comprehensive variance analysis, i.e. computing the price variances and quantity variances.

6.     How do you dispose of the variances for the variable and fixed costs on the books of the company?

7.     How is the report from question 5 useful to improve the cost control systems of the firm?



            When Sharon Michaels arrived at her office at Waltham Motors Division on June 4, 2004, she was pleased to find the monthly performance report for May on her desk.  Her job as division controller was to analyze results of operations each month and to prepare a narrative report on operations that was to be forwarded to the corporate headquarters of Marco Corporation.  Waltham Motors was a wholly owned subsidiary of Marco.  The atmosphere at the division had been one of apprehensiveness throughout the month of May, and today would provide a chance to find out how well division management had compensated for the recent loss of a major customer contract.

The Current Situation

            Waltham Motors manufactured electric motors of a single design that were sold to household appliance manufacturers.  Originally a family-owned business, the division had been acquired in late 2003 by the Marco Corporation.  Few changes had been made in either the company’s operating procedures or systems because Marco’s management had chosen to delay changing procedures and systems until it was able to observe how well those already in use at Waltham functioned.  In April, Sharon Michaels, who had earned a master’s degree in business administration in 2002, was transferred from the corporate headquarters controller’s office to Waltham Motors.  She was joined in late May by David Marshall, also from Marco, who was to be the new division manager.

            Because of the lost contract, Michaels had asked the plant accountant to assemble the May figures as quickly as possible, but she was amazed that they were ready so soon.  At headquarters, monthly results had rarely been available until several days after the end of each month.  Even though the plant accountant had promised Sharon that he would be able to prepare the report in a single day with some overtime work, she was surprised that he had been able to do so.

            The division had prepared a budget for 2004 based on estimated sales and production costs.  Because sales were not subject to seasonal fluctuations, the monthly budget was merely one-twelfth of the annual budget.  No adjustments had been made to the May budget when the contract was lost in April.

The Performance Report

            A glance at the performance report confirmed Michaels’s worst fears.  Instead of a budgeted profit of $91,200, the report showed the division had lost $7,200 in May.  Even allowing for the lost volume, she had expected a better showing than indicated by the performance report.  The plant accountant had attached the following memo to the report:        June 3, 11:00 P.M.


As promised, here is the performance report for May. (I told you smaller is better; we’ll show headquarters how efficient our plant accounting department is!)  I am sure you’ll find the bottom line as disappointing as I did, but plant performance really looks good, and the crews there may deserve our compliments.  Note how they are at or under budget on every single cost except for supervision.  I suspect that the unfavorable variance in supervision was caused directly by the work involved in controlling other costs.

            Because I worked late, I am taking a day off tomorrow.  The other data you requested are as follows:

1.      There were no beginning and ending inventories in work in progress or finished goods.

2.      Per unit standard costs used in budgeting this year were:

Direct material            $ 6

Direct labor                 16

3.      We are still using two hours per unit as standard labor time.

4.      Actual material prices have been 5% less than expected.

5.      Actual direct labor costs have been $8.20 per hour due to the increase in medical benefits granted last January.

A copy of the performance report is shown as Exhibit 1.

Waltham Motors Division

Exhibit 1        Performance Report, May 2004

                                                                                    Budget             Actual             Variance        

Units                                                                                18,000              14,000                4,000

Sales                                                                            $864,000          $686,000          $178,000       U

Variable manufacturing costs:

            Direct material                                                 $108,000          $ 85,400           $ 22,600        F

            Direct labor                                                        288,000          246,000              42,000        F

            Indirect labor                                                        57,600             44,400              13,200        F

            Idle time                                                               14,400             14,200                   200        F

            Cleanup time                                                        10,800             10,000                   800        F

            Miscellaneous supplies                                           5,200               4,000                1,200        F

            Total variable manufacturing cost                      $484,000          $404,000          $ 80,000        F

Variable shipping costs                                                 $  28,800          $  28,000          $      800        F

            Total variable costs                                           $512,800          $432,000          $ 80,800        F

Contribution margin                                                     $351,200          $254,000          $ 97,200        U

Nonvariable manufacturing costs:

            Supervision                                                      $  57,600          $  58,800          $   1,200        U

            Rent                                                                     20,000              20,000                    ---

            Depreciation                                                        60,000              60,000                    ---

            Other                                                                   10,400              10,400                    ---

Total nonvariable manufacturing costs               $148,000          $149,200          $   1,200        U

Selling and administrative costs                                      112,000            112,000                    ---

            Total nonvariable and programmed costs            $260,000          $261,200          $   1,200        U

Operating income (loss)                                                   91,200              (7,200)           (98,400)      U

Tutorials for this Question

Available for

BUSN6070 Waltham Motors Assignment

Tutorial # 00611973
Posted On: 06/29/2020 04:01 AM
Feedback Score: Not rated yet!
Puchased By: 0
Posted By:
Feedback Score:
Report this Tutorial as Inappropriate
Tutorial Preview …xssxgnmxnt xxxxxxxx…
BUSN6070_Waltham_Motors_xlsx_(1).xlsx (33.61 KB)
Preview: Prxcx x Bxdgxtxd xxxxxx x xctxxl xxxxxxxxxxxxxxxxx Lxbxr:xffxcxxncy Vxrxxncx:(xctxxl xxxxxxxx - xxxxxxxx xxxxxxxxx x xxxxxxxx PrxcxDxrxct Mxtxrxx xxxxxxxxxx VxrxxncxDxrxct lxbxr xxxx vxrxxncxDxrxct xxxxx xxxxxxxxxx Vxrxxncxxnfxvxrxblx xxxx xf Gxxds xxxxxxxxx Sxld TxtxlDxrxct xxxxxxx prxcx xxxxxxxxxxx xxxxxxxx Fxvxrxblx xxxxxxxxx Dxcrxxsxs xn xxxxxxxxxxx mxthxd xf xxxxxxxx dxspxsxtxxn xx xx xppxrtxxn xxx vxrxxncxs xmxng xxxxxxxxxxxxxxx xnvxntxry, Fxnxshxd-Gxxds xxxxxxxxxx xnd xxxx xx Gxxds xxxx Thxs xccxxntxng xxxxxxxxx rxflxcts thx xxxxxxx xf xxxxxxx xxxxxxxxxxxx xr xxxxxxxxxx xn xll xx thx xccxxnts xxxxxxx whxch xxx xxxxxxxxxxxxxxx flxw xxx xnfxvxrxblx vxrxxncxs xxxxxxxxx.....
Waltham_Motors_Performance_Report_(2).docx (37.06 KB)
Preview: fxr xxx dxrxct xxxxxxxx cxst xs xxxxxxxx thxs xs x rxflxctxxn xx xxx vxrxxblx xxxx pxr xnxt xxxxxxx xf thx xxxxxxx rxpxrtxd xx xxxxxxxxxxx stxtxmxnt xxx cxmpxny xlsx xxxxxxxxx fxr thx xxxxxx lxbxxr xxxx xxx xnxt xx xbxxt $16 xxx whxlx thx xxxxxxx xn xxx xxxxxx xs xxxxxx xt $16 xx Dxrxng mxnxfxctxrxng, xxx dxrxct xxxxx xxxx pxr xxxx wxs bxdgxtxd xx $17 57 xxx xnxt xxxxxxxxxx xxx cxmpxny’s xxxxxx lxbxxr cxsts xxx xnflxtxd tx xxxxxxx xr xx xx pxr xxxx xpxrxtxng xncxmx xx dxrxctly xffxctxd; xxx vxrxxncx xxx xx xssxcxxtxd xxxx sxvxrxl fxctxrs xxxx xs thx xxxxxxxxxxxxx xf xxxxxx xxxxx xnxts xxxxxxx xf thx xxxxxx thxt hxd xxxx bxdgxtxd xxx xxx thx xxxx cxntrxl prxcxss xx xmprxvxd?Fxnxncxxl rxpxrtxng xxx bxdgxtxng xxx xxxx xmpxrtxnt xxxxx xf lxxnchxng xxxx cxntrxl xn xxx fxnxncxxl xxxxxxxxxx xxxxxx Thxrxfxrx, xx thx cxmpxny xxxxx tx mxnxgx xxx xffxxrs xxxxxxxxxxx xxx cxmprxhxnsxvxly, xxx bxdgxtxng prxcxss xxxxxx bx mxrx xxxxxxxxxx mxrx xxxxxxxxxxxxx xxx mxrx xxxxxxxxx xt xll xxxxx Thx vxrxxblx xxx fxxxd xxxxx xxx xlsx xxxxxxx xn rxgxrd xx thx cxmpxny’s xxxxx xnxts xx xxx xnpxts xx xxtlxnxd Thxrxfxrx, xxx mxnxgxr’s spxctrxm xxxxx thx xxxxxxx xxxx bx xxxxxxxxx xnd hx xx shx wxll xx vxxwxng xxx xxxxxxx xn x lxrgxr pxrspxctxvx xxxx xsxxl xn xxxxxxx thx xxxxxxxxxxx xxxxxxxxxxxxx wxll xx xmprxvxd xs xx txkxs thrxxgh xxx mxnxfxctxrxng xxxxxxxxx xx thx xxxxxx xvxn xs xxx bxsxnxss xpxrxtxs xxxxxxx x xxxxxxxx xxxxxx xnd xxxxxxxx thx lxnx xx lxnx vxrxxncxs xxx dxxs xxxx xxxxxx cxmpxrx xxxx thx rxpxrt xxxxxxxxx xn qxxstxxn xx Flxxxblx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Rxvxnxx$686,00014,000F$672,000192,000x$864,000Vxrxxblx xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Mxrgxn$254,00019,156F$273,15678,044x$351,200Fxxxd Cxst$260,0000x260,0000$260,000xpxrxtxng xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx x cxmprxhxnsxvx xxxxxxxx xnxlysxs, x x cxmpxtxng xxx prxcx.....
* - Additional Paypal / Transaction Handling Fee (5% of Tutorial price + $0.30) applicable