Prime Packaging Ltd manufactures and sells a variety of packaging solutions. As a means of monitoring...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Prime Packaging Ltd manufactures and sells a variety of packaging solutions. As a means of monitoring performance, performance reports are prepared on a monthly basis. The production manager is struggling to pull together their report so have asked you, as the management accountant to assist them. Outlined below is what the production manager has managed to prepare so far. Labour hours (per unit) Prime Packaging Ltd Production department flexible budget performance report For the month ended 30 June Total expenses Actual results Direct labour Indirect labour Utilities Supplies Equipment depreciation ? Factory administration ? 9,480 B) Utilities Supplies Equipment depreciation Factory administration £134,73 3880 ? 2 Fav Spending (F)/Adv Flexible variance (A) budget 0? £4,940 ? £288,08 ? 8? The following information is also available: Cost Direct labour (DL) Indirect labour ? £1,780 F £1,450 A ? £0 ? ? ? ? £132,72 2 0? £21,640 ? ? ? Activity Fav variance (F)/Ad v (A) ? S £4,444 ? ? ? ? ? ? 2427 Actual and budgeted direct labour rates The fixed cost element of the indirect labour The variable cost per hour for utilities The fixed and variable cost elements for supplies £336 A ? ? ? Detail Direct labour rate x direct labour hours Ex fixed variable (£1.50 per DL hour) £6,500 fixed variable (Ex per DL hour) Ex fixed variable (Ex per DL hour) £78,400 £18,700 + variable (£1.90 per DL hour) Plannin 9 budget ? ? £12,800 £4,300 ? ? Requirement: A) Complete the production department's flexible budget performance report (by filling in the question marks). The workings should be completed in an excel spreadsheet with the final flexible budget presented in a PowerPoint presentation, along with high level details of the workings. Within your presentation include the following: 9,000 ? comment on the performance of the production department. including what action the department may what to take going forward. C) The production department is considered a cost centre within Prime Packaging Ltd, outline what considerations should be given to determine how much involvement the production department should have in setting their departmental targets. Prime Packaging Ltd manufactures and sells a variety of packaging solutions. As a means of monitoring performance, performance reports are prepared on a monthly basis. The production manager is struggling to pull together their report so have asked you, as the management accountant to assist them. Outlined below is what the production manager has managed to prepare so far. Labour hours (per unit) Prime Packaging Ltd Production department flexible budget performance report For the month ended 30 June Total expenses Actual results Direct labour Indirect labour Utilities Supplies Equipment depreciation ? Factory administration ? 9,480 B) Utilities Supplies Equipment depreciation Factory administration £134,73 3880 ? 2 Fav Spending (F)/Adv Flexible variance (A) budget 0? £4,940 ? £288,08 ? 8? The following information is also available: Cost Direct labour (DL) Indirect labour ? £1,780 F £1,450 A ? £0 ? ? ? ? £132,72 2 0? £21,640 ? ? ? Activity Fav variance (F)/Ad v (A) ? S £4,444 ? ? ? ? ? ? 2427 Actual and budgeted direct labour rates The fixed cost element of the indirect labour The variable cost per hour for utilities The fixed and variable cost elements for supplies £336 A ? ? ? Detail Direct labour rate x direct labour hours Ex fixed variable (£1.50 per DL hour) £6,500 fixed variable (Ex per DL hour) Ex fixed variable (Ex per DL hour) £78,400 £18,700 + variable (£1.90 per DL hour) Plannin 9 budget ? ? £12,800 £4,300 ? ? Requirement: A) Complete the production department's flexible budget performance report (by filling in the question marks). The workings should be completed in an excel spreadsheet with the final flexible budget presented in a PowerPoint presentation, along with high level details of the workings. Within your presentation include the following: 9,000 ? comment on the performance of the production department. including what action the department may what to take going forward. C) The production department is considered a cost centre within Prime Packaging Ltd, outline what considerations should be given to determine how much involvement the production department should have in setting their departmental targets.
Expert Answer:
Answer rating: 100% (QA)
A To complete the production departments flexible budget performance report we need to fill in the missing values Based on the information provided we can calculate the missing values as follows 1 Act... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-1259307416
16th edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
The trading company EPSILON on 31/12/21 in its 2nd Provisional Balance had the following Accounts. 600,000 buildings. Debt Interest and related expenses 20,000, Transportation expenses 10,000, K.O...
-
Let f(x) = 2x + 1 and let g(x): f(g(2)) = g(f(2)) Suppose that h() is the function described by the input-output table below. X h(x) 01234 h(h(2)) 2 1 = 3 1 0 = 3x. If u(x) = x + 2x and v(x) = 3x +...
-
Information for Sponge-Fun Products is provided in P8-36B. In P8-36B SpongeFun Products manufactures and sells a variety of swimming products. Recently, the company opened a new plant to manufacture...
-
What is the advantage of using computing to simulate an automobile crash test as opposed to actually staging a crash?
-
Triplet excited states some organic molecules have a triplet (S = 1) excited state at an energy k B above a singlet (S = 0) ground state. (a) Find an expression for the magnetic moment () in a field...
-
In creating a frequency distribution table, which of the following statements is not a basic rule to follow? a. Choose classes that cover the smallest and largest values. b. Make certain that each...
-
The following data are taken from Stockton Wholesale Company's May payroll: Assume that the company is subject to a two percent state unemployment tax (due to a favorable experience rating) and a 0.6...
-
Bad-Debt ReportingAging Mani Low Corporation operates in an industry that has a high rate of bad debts. Before any year-end adjustments, the balance in Mani lows Accounts Receivable account was...
-
A portfolio has 3 0 % of its value in IBM shares and the rest in Microsoft ( MSFT ) . The volatility ( standard deviation ) of IBM and MSFT are 2 5 % and 3 6 % , respectively, and the correlation...
-
Choice Designs Ltd operates a wholesale/retail carpet store. The statement of financial position of the business as at 31 May Year 8 is as follows: As a result of falling profits the directors of the...
-
Given the following information, compute the materials price variance and the materials quantity variance. For each variance, state whether it is favorable or unfavorable. Show your calculations....
-
Following are selected income statement and balance sheet data for two communications companies: Comcast and Verizon, for the year ended December 31, 2012. Income Statement ($ millions) Comcast...
-
Solve the equation 6 x 4 + x = 5 x 3 + 2 x 2
-
6) Find the derivative and simplify your answer: e2x y = x +9
-
Find the variable cost per unit, total fixed cost, and total cost. Prescription Volume Labor Cost High Data Point Low Data Point 20,545.00 11,374.00 $86,245.00 $49,182.00 Find the Variable Cost per...
-
Java: Update your "word occurrences" application. Put a GUI on top of the word occurrences class. Try to follow the GUI guidelines and practices that you learned about, so that the GUI is clean and...
-
A 1 kg block slides down an incline. The incline is 5 m long and has an angle of 25 with the horizontal. There is friction between the block and the incline, with coefficient k = 0.15. Initially, at...
-
Chloroplasts are illuminated until the levels of the Calvin cycle intermediates reach a steady state. The light is then turned off. How does the level of RuBP vary after this point?
-
Wonderful Not only did our salespeople do a good job in meeting the sales budget this year, but our production people did a good job in controlling costs as well, said Kim Clark, president of Martell...
-
The Ferre Publishing Company has three service departments and two operating departments. Selected data from a recent period on the five departments follow: The company allocates service department...
-
Marwicks Pianos, Inc., purchases pianos from a large manufacturer for an average cost of $2,450 per unit and then sells them to retail customers for an average price of $3,125 each. The companys...
-
An increase in the demand for land will _________ the quantity supplied and _________ the price of land.
-
The supply of land is perfectly _________.
-
_________ is the price paid for land or any other factor that has a fixed supply.
Study smarter with the SolutionInn App