Sky has set up a jam-making business and is calculating the raw material requirements for the year ahead. Her sales estimates and raw materials usage assumptions are as follows: TABLE 1: Jam sales budget in units (jars) Gooseberry 245,000 Rhubarb 60,000 5,500 Sales units (jars) Opening inventory (jars) 30,000 TABLE 2: Jam raw material usage assumptions Fruit per jar Sugar per jar Gooseberry 0.7kg 0.6kg Rhubarb 1.1kg 1.0kg Calculate: (i) The production budget (in quantities) using the opening inventory assumptions in Table 1 above and assuming that closing inventory should be 10% of sales units. (ii) The materials budget (in quantities), identifying how much of each type of raw material is required. (iii) The total raw material purchase budget (in value £ and to the nearest whole £) if gooseberries cost £1.60 per kg; and rhubarb cost £2.25 per kg. Sugar costs £0.21 per kg, jars cost £0.15 each, lids cost £0.02 each and labels (one per jar) cost £0.01 each.

Sky has set up a jam-making business and is calculating the raw material requirements for the year ahead. Her sales estimates and raw materials usage assumptions are as follows: TABLE 1: Jam sales budget in units (jars) Gooseberry 245,000 Rhubarb 60,000 5,500 Sales units (jars) Opening inventory (jars) 30,000 TABLE 2: Jam raw material usage assumptions Fruit per jar Sugar per jar Gooseberry 0.7kg 0.6kg Rhubarb 1.1kg 1.0kg Calculate: (i) The production budget (in quantities) using the opening inventory assumptions in Table 1 above and assuming that closing inventory should be 10% of sales units. (ii) The materials budget (in quantities), identifying how much of each type of raw material is required. (iii) The total raw material purchase budget (in value £ and to the nearest whole £) if gooseberries cost £1.60 per kg; and rhubarb cost £2.25 per kg. Sugar costs £0.21 per kg, jars cost £0.15 each, lids cost £0.02 each and labels (one per jar) cost £0.01 each.

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter14: The Balanced Scorecard And Corporate Social Responsibility

Section: Chapter Questions

Problem 5E

See similar textbooks

Similar questions

Diagnostic Supplies has expected sales of 98,000 units per year, carrying costs of $5 per unit, and an ordering cost of $8 per order. a. What is the economic ordering quantity? Economic ordering quantity b-1. What is the average inventory? Average inventory b-2. What is the total carrying cost? Total carrying cost units units
Maulana Sdn Bhd (MSB) manufactures and sells two types of products: Pastry roller and Pastry puff Each unit of product consumes two types of materials, butter and cheese. MSB is preparing its annual budget for the year ending December 31, 2018. The Assistant Accountant provides the following data: Pastry roller Pastry puff 55,000 Sales unit 65,000 Unit selling price RM30 RM20 MSB decided that the beginning and ending inventory for the year 2018 are as follow: Product Beginning inventory(units) Ending inventory(units) Pastry roller Pastry puff +The following materials are needed for the production of pastry roller and pastry puff: 8,000 9,000 5,000 4,000 Pastry roller Beginning inventory (kg) inventory (kg) | 272,000 Materials: Pastry puff Ending 10 kg 8 kg 290,000 Butter Cheese |4 kg 3 kg 60,000 | 41,000 Price per ka Materials: Butter RM2.00 Cheese RM8.00 Direct labour per unit and direct labour coBer unit is given below: Hours needed Rate hour per Pastry roller 2 hours Pastry puff 1.5…
Barbara Flynn's company has compiled the data below on a small set of products. Based on the percentages of dollar volume, perform an ABC analysis on her data by completing the table below. Assume that class A items represent about 70% of the total dollar usage, class B-about 25%, class C-less than 5% (round your responses to the nearest whole number). Item A В C D E Annual Demand 200 50 160 150 300 Unit Cost $200 $150 $160 $150 $300 Annual Dollar Volume Classification $40,000 $7,500
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company’s products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Product DemandNext year(units) SellingPriceper Unit DirectMaterials DirectLabor Debbie 53,000 $ 19.00 $ 4.60 $ 4.40 Trish 45,000 $ 7.00 $ 1.40 $ 1.76 Sarah 38,000 $ 29.00 $ 6.89 $ 6.80 Mike 32,000 $ 13.00 $ 2.30 $ 5.20 Sewing kit 328,000 $ 8.30 $ 3.50 $ 1.36 The following additional information is available: The company’s plant has a capacity of 137,510 direct labor-hours per year on a single-shift basis. The company’s present employees and equipment can produce all five products. The direct labor rate of $8 per hour is expected to remain unchanged during the coming year. Fixed manufacturing costs total $550,000 per year. Variable overhead costs are $2 per direct labor-hour.…
Using the chart, I need assistance in answering the following questions w/ explanations: (The cost of the bags, which must be ordered in batches of 100) a) If this was a profit-making activity, at the entry fee of $20, what would be the profit-maximizing quantity of participants/bags? (I got 300 participants/bags) b) Use the information in the table to determine the exact breakeven quantity of participants/bags for the entry fee of $20. Use the formula Qb = F/(P – AVC). (I am not sure what to do or if I did this right. I got 113.)
A manufacturing company makes 10 different products. The sales of each product in the last year and the Cost/unit for storage are: Product Sales Cost/Unit 1 1500 6 2 160 6 3 4000 2.5 4 100 10 5 140 17.5 6 700 5 7 300 12 8 1200 3 9 5200 0.25 10 400 1.5 Sort the products in ABC and draw the chart: a) By sales. b) By storage cost. c) What is the optimal lay-out if the warehouse plant is (provide a simple drawing/sketch of the layout, thanks)
PFA Attached screenshot. Could you please help me with the correct solution.
Refer to Cornerstone Exercise 3.4 for data on Dohini Manufacturing Companys purchasing cost and number of purchase orders. The controller for Dohini Manufacturing ran regression on the data, and the coefficients shown by the regression program are: Required: 1. Construct the cost formula for the purchasing activity showing the fixed cost and the variable rate. 2. If Dohini Manufacturing Company estimates that next month will have 430 purchase orders, what is the total estimated purchasing cost for that month? (Round your answer to the nearest dollar.) 3. What if Dohini Manufacturing wants to estimate purchasing cost for the coming year and expects 5,340 purchase orders? What will estimated total purchasing cost be? (Round your answer to the nearest dollar.) What is the total fixed purchasing cost? Why doesnt it equal the fixed cost calculated in Requirement 1?
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company’s products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Product DemandNext year(units) SellingPriceper Unit DirectMaterials DirectLabor Debbie 50,000 13.50 4.30 3.20 Trish 42,000 5.50 1.10 2.00 Sarah 35,000 21.00 6.44 5.60 Mike 40,000 10.00 2.00 4.00 Sewing kit 325,000 8.00 3.20 1.60 The following additional information is available: The company’s plant has a capacity of 130,000 direct labor-hours per year on a single-shift basis. The company’s present employees and equipment can produce all five products. The direct labor rate of $8 per hour is expected to remain unchanged during the coming year. Fixed manufacturing costs total $520,000 per year. Variable overhead costs are $2 per direct labor-hour. All of the company’s…
Please help solve the question
he Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company’s products is increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Product DemandNext year(units) SellingPriceper Unit DirectMaterials DirectLabor Debbie 62,000 $ 20.50 $ 5.50 $ 3.60 Trish 54,000 $ 7.00 $ 2.30 $ 1.32 Sarah 47,000 $ 34.00 $ 8.24 $ 7.20 Mike 56,000 $ 15.00 $ 3.20 $ 4.80 Sewing kit 337,000 $ 9.20 $ 4.40 $ 0.72 The following additional information is available: The company’s plant has a capacity of 84,160 direct labor-hours per year on a single-shift basis. The company’s present employees and equipment can produce all five products. The direct labor rate of $12 per hour is expected to remain unchanged during the coming year. Fixed manufacturing costs total $640,000 per year. Variable overhead costs are $3 per direct labor-hour.…
1.B.) Rose Turkish Delight Company produces different types of Turkish delights. The following table shows the desired ending inventory levels of sugar which is one of the direct materials to produce Red Rose Product. According to production budget of the company, 2000 boxes of Red Rose will be produced in each quarter. Each box requires 1 kg sugar and estimated purchasing price of sugar is 10 TL per kg. 31.12.2021 31.03.2022 30.06.2022 30.09.2022 31.12.2022 Desired Ending Inventory balances of 100 kg 110 kg 120 kg 130 kg 140 kg Sugar Prepare a direct material (Sugar) budget for 2022.