Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For question 2 I just need last part Franklin Products Limited manufactures and distributes a number of products to retailers. One of these products, SuperStick,

For question 2 I just need last part image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Franklin Products Limited manufactures and distributes a number of products to retailers. One of these products, SuperStick, requires five kilograms of material D236 in the manufacture of each unit. The company is now planning raw materials needs for the third quarter-July, August, and September Peak sales of SuperStick occur in the third quarter of each year to keep production and shipments moving smoothly, the company has the following inventory requirements a. The finished goods inventory on hand at the end of each month must be equal to 1,600 units plus 20% of the next month's sales The finished goods inventory on June 30 is budgeted to be 22,720 units b. The raw materials inventory on hand at the end of each month must be equal to 40% of the following month's production needs for raw materials. The raw materials inventory on June 30 for material D236 is budgeted to be 131 400 kilograms. c The company maintains no work in process inventories A sales budget for SuperStick for the last six months of the year follows: Budgeted Sales in Units July 61,200 August 75,600 September 106,200 October 53,600 November 30,600 December 15, 240 Required: 1. Prepare a production budget for SuperStick for July, August September, and October July August September October Budgeted sales (units) 0 0 0 Total noods 0 0 0 Required production 2. Not available in Connect 3. Prepare a direct materials purchases budget showing the quantity of material D236 to be purchased for July, August, and September and for the quarter in total. July August September Third Quarter Required production (units) Material D236 nooded per unit (kgs.) Production noods (kgs.) 0 0 0 0 Total Material D236 needs 0 0 0 0 Material D236 purchases (kgs) The production department of Zan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year 4th 1st Quarter 6,000 2nd Quarter 9,000 3rd Quarter Quarter 8,000 7.ee Units to be produced In addition, 7.000 grams of raw materials inventory is on hand at the start of the 1st quarter and the beginning accounts payable for the 1st quarter is $3,880. Each unit requires 9.00 grams of raw material that costs $1.40 per gram Management desires to end each quarter with an inventory of raw materials equal to 30% of the following quarter's production needs. The desired ending inventory for the 4th quarter is 9,000 grams. Management plans to pay for 50% of raw material purchases in the quarter acquired and 50% in the following quarter Each unit requires 0.30 direct labour-hours and direct labourers are paid $9.50 per hour Required: 1. Prepare the company's direct materials purchases budget and schedule of expected cash disbursements for materials for the upcoming fiscal year Roquired production in units of finished goods Units of raw materials needed per unit of finished goods Units of raw materials needed to moot production Add: Desired units of onding raw materials inventory Total units of raw materials needed Less: Units of beginning raw materials inventory Units of raw materials to be purchased Unit cost of raw materials Cost of raw materials to be purchased Zan Corporation Direct Materials Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year 6,000 9.0001 8,000 7,000 30,000 9.00 9.00 9.00 9.00 9.00 54,000 81.000 72.000 63,000 270,000 24,300 21,600 18,900 9,000 9,000 78,300 102.600 90.900 72000 279,000 (7.000) (24.300) (21,600) (18,900) (7,000) 71,300 78,300 69,300 53,100 272,000 $ 1.407 s 1.401 $ 1.40 $ 1.40 $ 99,820 S 100,620 $ 97.020 $ 74,340 $ 0 Schedule of Expected Cash Disbursements for Materials Beginning accounts payable $ 3,880 1st Quarter purchases 39,350 2nd Quarter purchases 35,650 39,150 3rd Quarter purchases 39,150 34,650 4th Quarter purchases 34,650 Total cash disbursements for materials $78,880 $ 78,300 $ 69,300 $ 39.250 74,800 73,800 26,550 61,200 26,550 $ 249,050 2. Prepare the company's direct labour budget for the upcoming fiscal year, assuming that the direct labour workforce is adjusted each quarter to match the number of hours required to produce the forecast number of units produced Zan Corporation Direct Labour Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Year Required production in units Direct labour-hours per unit Total direct labour hours needed Direct labour cost per hour Total direct labour cost 0 0 0 0 0 $ 0 $ 0 $ 0 $ 0 $ 0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting And Analysis In Multinational Enterprises

Authors: H P Holzer

1st Edition

3110100819, 978-3110100815

More Books

Students also viewed these Accounting questions

Question

How do books become world of wonder?

Answered: 1 week ago