SKILLS O EMPLOYABILITY SKILLS Scenario: DG Ltd G Ltd manufactures gaming consoles for ado- years age....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
SKILLS O EMPLOYABILITY SKILLS Scenario: DG Ltd G Ltd manufactures gaming consoles for ado- years age. The management accountant, Mrs Ruva Tamic, is keen to keep a tight control over the costs as she is working closely with the marketing director MONTH August September October November December January February March April May June July OUTPUT (X1) (UNITS) 902 950 987 1,250 1,342 1,423 1,987 2,321 750 2,665 2,210 2,342 NO. OF EMPLOYEES (X2) 90 85 100 105 103 110 123 140 78 150 118 115 You have been given the following additional information: The management accountant has been consid- ering ways to forecast the total production costs. She wants to choose one of the independent vari- ables from X1, X2 and X3 and use the least-squares regression equation to help her make this decision. Practical tasks Use a spreadsheet to complete the following tasks: 1 Using the least-squares method, calculate a and b for all the three variables. 2 Calculate the correlation coefficient, the coefficient of determination and explain what they mean for all three variables. 3 Using the values calculated in task 1, calculate how many employees, units or labour hours would have been incurred if the total cost was £875,000. who wants to enter the market with a penetration pricing strategy. They aim to have a low entry price and gain a significant market share of the gaming industry. The management accountant has been encour- aged by the marketing director to try to use regres- sion analysis to estimate the total costs. Information has been collated for the coming 12-month period up to 31 August and is presented below: ASSESSMENT MATERIAL DIRECT LABOUR (X3) (HOURS) 5,436 5,643 6,543 7,765 7,632 8,765 9,765 11,765 4,509 12,564 10,543 10,123 6 TOTAL COST Y (£) 234,987 265,432 276,543 245,321 276,890 296,754 271,298 310,456 230,000 312,453 306,587 304,576 4 Use the values calculated in task 1 to demonstrate how these can be used to forecast the total cost for 13,312 units, 500 employees and 522,341 labour hours. Research and presentation Using PowerPoint, provide the following: After viewing your calculation in task 4, Mrs Ruva Tamic noticed that they give very similar values. She is now confused which of the three variables would be best to use for forecasting the total cost. 5 Select and explain which is the best estimator for acquiring the forecast of the total cost from the independent variables of X1, X2 and X3. 707 graphs to demonstrate the concept of correlation and support your choice of variable. SKILLS O EMPLOYABILITY SKILLS Scenario: DG Ltd G Ltd manufactures gaming consoles for ado- years age. The management accountant, Mrs Ruva Tamic, is keen to keep a tight control over the costs as she is working closely with the marketing director MONTH August September October November December January February March April May June July OUTPUT (X1) (UNITS) 902 950 987 1,250 1,342 1,423 1,987 2,321 750 2,665 2,210 2,342 NO. OF EMPLOYEES (X2) 90 85 100 105 103 110 123 140 78 150 118 115 You have been given the following additional information: The management accountant has been consid- ering ways to forecast the total production costs. She wants to choose one of the independent vari- ables from X1, X2 and X3 and use the least-squares regression equation to help her make this decision. Practical tasks Use a spreadsheet to complete the following tasks: 1 Using the least-squares method, calculate a and b for all the three variables. 2 Calculate the correlation coefficient, the coefficient of determination and explain what they mean for all three variables. 3 Using the values calculated in task 1, calculate how many employees, units or labour hours would have been incurred if the total cost was £875,000. who wants to enter the market with a penetration pricing strategy. They aim to have a low entry price and gain a significant market share of the gaming industry. The management accountant has been encour- aged by the marketing director to try to use regres- sion analysis to estimate the total costs. Information has been collated for the coming 12-month period up to 31 August and is presented below: ASSESSMENT MATERIAL DIRECT LABOUR (X3) (HOURS) 5,436 5,643 6,543 7,765 7,632 8,765 9,765 11,765 4,509 12,564 10,543 10,123 6 TOTAL COST Y (£) 234,987 265,432 276,543 245,321 276,890 296,754 271,298 310,456 230,000 312,453 306,587 304,576 4 Use the values calculated in task 1 to demonstrate how these can be used to forecast the total cost for 13,312 units, 500 employees and 522,341 labour hours. Research and presentation Using PowerPoint, provide the following: After viewing your calculation in task 4, Mrs Ruva Tamic noticed that they give very similar values. She is now confused which of the three variables would be best to use for forecasting the total cost. 5 Select and explain which is the best estimator for acquiring the forecast of the total cost from the independent variables of X1, X2 and X3. 707 graphs to demonstrate the concept of correlation and support your choice of variable.
Expert Answer:
Answer rating: 100% (QA)
Answer 1 Using the leastsquares method calculate a and b for all the three variables The least squares method is a statistical technique used to calculate the bestfit line for a given set of data poin... View the full answer
Related Book For
Using Financial Accounting Information The Alternative to Debits and Credits
ISBN: 978-1133161646
7th Edition
Authors: Gary A. Porter, Curtis L. Norton
Posted Date:
Students also viewed these finance questions
-
The table that follows shows the components of M1+, M2, and M2+ in billions of dollars from January 2016 to March 2017 as published in the Bank of Canada's Banking and Financial Statistics published...
-
Using the seven steps of the quantitative analysis approach, model the need for a sales projection in a supermarket. Make the projections with the following data from the table. Make the projections...
-
Lancer Audio produces a high-end DVD player that sells for $1,300.Total operating expenses for the past 12 months are as follows: Required a. Use regression analysis to estimate fixed and variable...
-
Please help I am confused and really stuck here and can't properly answer this one. Does it meet all the assumptions? b. Do the data meet all the assumptions of the appropriate statistical test...
-
Badger Corporation declared a stock dividend to all shareholders of record on March 25 of this year. Shareholders will receive one share of Badger stock for each ten shares of stock they already own....
-
A 1-m-diameter bike tire is pumped up to 500 kPa. It is assumed to have a circular cross section with a diameter of 2 cm. The mass of 20 C air in the tire is nearest: (A) 0.0059 kg (B) 0.0082 kg (C)...
-
Sherry Taft and I.aura Sims are opening Bank Compliance Consultants. The area is growing, and no competitors are located nearby. Their basic decision is how to organize the business. Taft thinks the...
-
A data set of 5 observations for Concession Sales per person ($) at a theater and Minutes before the movie begins results in the following estimated regression model: Sales = 4.3 + 0.265 Minutes. The...
-
brief report answering the following questions. Define the service package of Menlo college. What is its strongest element? What is its weakest one? Some people tend to use the terms effectiveness...
-
The towline exerts a force of P = 4 kN at the end of the 20-m-long crane boom. If x = 25 m, determine the position ? of the boom so that this force creates a maximum moment about point O. What is...
-
Figure 2 shows a cross section through a system that consists of an infinitely long charged rod centred in a thick cylindrical shell of inner radius R and outer radius 2R. The shell is made of a...
-
31) (a) Prove that A(n) - A(0) = I1 + I2 + ... + Inton louis (b) Verbally interpret the result from part (a) (c) Is it true that a(n) - a(0) = i + 12 + ... + in? Explain.
-
What is the intial velocity vector if a ball covered 2 5 m horizontally in a 2 second flight?
-
The Rolling Rock Restaurant records its payroll weekly for salaried and hourly rate employees separately. Jessica Talbot and Kristen Millar are salaried employees. There annual salaries are...
-
Fidelity Fund II is considering new stock selection analysis as follows: Stock A Stock B Nikkei (A,B) 6 month Tbill 1- E(R) Portfolio 1 Portfolio 2 Portfolio 3 10% 8% 8% Stock A 40% 30% 60% -0,5 3% 6...
-
3. You have the following payoff table for a decision analysis problem. Payoffs are in units of thousands of dollars of profit. STATE OF NATURE ALTERNATIVES S S Sj St d 35 50 45 40 d 45 40 30 60 d 20...
-
The ________ is required to prepare the cash budget of an organization. Question content area bottom Part 1 A. budgeted balance sheet B. capital expenditures budget C. statement of shareholders'...
-
(a) Bright Sdn Bhd (BSB) is a tax resident manufacturing company in Johor, which involves in ceramic tiles. Currently, BSBs annual sales turnover has been forecasted to be around RM 300,000 for the...
-
Maple Corp. owns a building with an original cost of $1,000,000 and accumulated depreciation at the balance sheet date of $200,000. Based on a recent appraisal, the fair value of the building is...
-
What is the significance of source documents to the recording process? Give two examples of source documents.
-
Accelerated Depreciation Koffmans Warehouse purchased a forklift on January 1, 2010, for $6,000. The forklift is expected to last for five years and have a residual value of $600. Koffmans uses the...
-
Calculate the acentric factor for ethanol. The vapour pressure of ethanol can be estimated from the following equation: \[ \log _{10} P^{\text {Sat }}=8.1122-\frac{1592.864}{t+226.184} \] where...
-
For liquid acetone at \(20^{\circ} \mathrm{C}\) and \(1 \mathrm{bar}\), \[ \beta=1.487 \times 10^{-3} /{ }^{\circ} \mathrm{C} \quad \alpha=62 \times 10^{-6} / \mathrm{bar} \quad V=1.287...
-
Determine the molar volume of ammonia vapour and ammonia liquid at \(321.55 \mathrm{~K}\) and 1.95 \(\mathrm{MPa}\). Ammonia is assumed to follow van der Waals equation of state.
Study smarter with the SolutionInn App