Reference no: EM131048445
Management Accounts Budgeting Assignment
XGame Ltd
XGame Ltd is a small company which manufactures a popular children's game. The company has decided to produce cash budgets and production budgets to ensure that its operations are better planned and more carefully controlled.
Budgeted production and sales for six months ending 30 June 2016are as follows:
Production Sales
Units Units
Jan 1200 1400
Feb 1200 1300
Mar 1300 1300
April 1400 1500
May 1500 1600
June 1600 1800
Financial Information
- Variable factory overheads are expected to increase by 10% in May and remain at this level in June.
- Fixed factory overheads have been set at a 10% increase on last year.
- It has been decided to increase the selling price from £25 per gameto £27 fromApril onwards. Sales are made on one month's credit. Purchases of the raw materials are two months credit.
- The company has decided to purchase a new more efficient machine. The machine will cost£50,000 and is expected to be paid for in March.
Task1-
The Cash Flow Budget has been prepared but has not yet been adjusted for the New Machinery. Refer to Excel Spreadsheet 1.
You are required to make the adjustment for the New Machinery and prepare brief notes for your manager. The notes should answer the following questions:
a. Explain how the purchase of the New Machinery affects the Cash Flow, and clearly state the problem.
b. Analyse THREE alternative solutions to the problem that you identified.
- You should explain how each solution would overcome the problem
- You should also identify any problems arising from the solutions.
Task 2-
It is now July 2016 and the profit and loss budget variance has been prepared showing the budgeted and the actual figures for the period ending30th June 2016. Refer to Excel Spreadsheet 2.
You are required to complete the A/F and percent columns and prepare brief notes for your manager. The notes should answer the following questions:
a. Identify the THREE significant (largest) variances. Include the level of the significance and state whether favourable or adverse.
b. Analyse the THREE variances that you identified.
- You should identify the possible causes of each variance
- You should provide possible recommendations on how to overcome or prevent the variance in the future.
Attachment:- Data.rar
|
Write a report about the companys stock
: Each student will choose a publically traded corporation on either the NYSE or NASDAQ and write a 5+ page report about the company's stock. Including, years in business, current performance, how it compares to the competition etc.
|
|
Comment on control of short-term process variation
: A cutting operation. A machine tool in your plant is cutting an outside diameter. A sample of 4 pieces is taken near the end of each hour of production. Table 27.7
|
|
What is the firms accounts receivable turnover
: What is the firm's accounts receivable turnover? What is the firm's accounts receivable period? What is the firm's accounts receivable balance at the beginning of April 2016?
|
|
Calculate balance of direct materials control account
: Given this incomplete information, complete the template below and calculate the beginning balance of the Direct Materials Control account
|
|
How the purchase of the new machinery affects the cash flow
: You are required to make the adjustment for the New Machinery and prepare brief notes for your manager. The notes should answer the following questions: Explain how the purchase of the New Machinery affects the Cash Flow, and clearly state the pro..
|
|
Center lines and limits calculated from these past data
: Hospital losses. Table 27.6 gives data on the losses (in dollars) incurred by a hospital in treating major joint replacement (DRG 209) patients.13 The hospital has taken from its records a random sample of 8 such patients each month for 15 months.
|
|
Build the spreadsheet model for three given option
: build the spreadsheet model for three option. do not have to include sensitivity or breakeven. just do as much as you can thanks.
|
|
Estimating process parameters
: Estimating process parameters. The and s control charts for the meshtensioning example (Figures 27.4(b) (page 27-13) and 27.7 (page 27-19)) were based on µ= 275 mV and σ =43 mV. Table 27.1 (page 27-12) gives the 20 most recent samples from this ..
|
|
The viscosity of a material
: From setup to monitoring. Suppose that when the chart setup project of Example 27.8 is complete, the points remaining after removing special causes have = 48.7 and = 0.92. What are the center line and control limits for the and s charts you woul..
|