Management accounting week 7 solution PDF

Preview

Summary

quiz week 7 solution...

Description

Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South East Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company’s products. The company now is planning raw materials needs for the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements: a. The finished goods inventory on hand at the end of each month must equal 3,000 units of Supermix plus 25% of the next month’s sales. The finished goods inventory on June 30 is budgeted to be 19,250 units. b. The raw materials inventory on hand at the end of each month must equal one-half of the following month’s production needs for raw materials. The raw materials inventory on June 30 is budgeted to be 99,375 cc of solvent H300. c. The company maintains no work in process inventories. A monthly sales budget for Supermix for the third and fourth quarters of the year follows. Budgeted Unit Sales July 65,000 August 70,000 September 80,000 October 60,000 November 50,000 December 40,000

Required: 1. Prepare a production budget for Supermix for the months July, August, September, and October. 3. Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter in total.

GPrepare a production budget for Supermix for the months July, August, September, and October.

Pearl Products Limited Production Budget July Budgeted unit sales Add: Desired units of ending finished goods inventory

August September October

65,000 70,000

80,000

60,000

20,500 23,000

18,000

15,500

Total needs

85,500 93,000

98,000

75,500

Less: Units of beginning finished goods inventory

19,250 20,500

23,000

18,000

Required production in units

66,250 72,500

75,000

57,500

arrison 16e Rechecks 2017-05-18 rev: 03_06_2018_QC_CS-120799 Pearl Products Limited Direct Materials Budget July

August

September

Required production in units of 66,250 72,500 75,000 finished goods Units of raw materials needed 3 cc 3 cc 3 per unit of finished goods Units of raw materials needed to 198,750 217,500 225,000 meet production Add: Desired units of ending 108,750 112,500 86,250 raw materials inventory Total units of raw materials 307,500 330,000 311,250 needed Less: Units of beginning raw 99,375 108,750 112,500 materials inventory Units of raw materials to be purchased

208,125

221,250

Garrison 16e Rechecks 2017-05-18, 2018-09-26 Garrison_16e_Rechecks_2019_10_14 Explanation 1.

198,750

Desired units of ending finished goods inventory in October month: October: 3,000 units + (50,000 units × 25%) = 15,500 units.

3. Desired units of ending raw materials inventory in September month: 57,500 units (October production) × 3 cc per unit = 172,500 cc. 172,500 cc × 1/2 = 86,250 cc.

As shown in part (1), production is greatest in September; however, as shown in the raw material purchases budget, purchases of materials are greatest a month earlier—in August. The reason for the large purchases of materials in August is that the materials must be on hand to support the heavy production scheduled for September.

Schedules of Expected Cash Collections and Disbursements; Income Statement; Balance Sheet [LO8-2, LO8-4, LO8-9, LO8-10] [The following information applies to the questions displayed below.] Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash Accounts receivable Inventory Plant and equipment, net of depreciation Total assets

$ 84,000 144,000 63,750 223,000 $514,750

Liabilities and Stockholders’ Equity Accounts payable

$ 84,000

Common stock

349,000

Retained earnings

81,750

Total liabilities and stockholders’ equity$514,750

Prepare a schedule of expected cash collections for July, August, and September.

Schedule of Expected Cash Collections

From accounts receivable From July sales From August sales From September sales Total cash collections

July $144,000 119,000

Month August September 221,000 126,000

$263,000 $347,000

Quarter $144,000 340,000 234,000 360,000 122,500 122,500 $356,500 $966,500

Prepare a merchandise purchases budget for July, August, and September. Also compute total merchandise purchases for the quarter ended September 30.

Merchandise Purchases Budget July August September Quarter Budgeted cost of goods sold $255,000 $270,000 $262,500 $787,500 Add: Desired ending merchandise 67,500 65,625 69,375 69,375 inventory Total needs 322,500 335,625 331,875 856,875 Less: Beginning merchandise inventory 63,750 67,500 65,625 63,750 Required purchases $258,750 $268,125 $266,250 $793,125 Prepare a schedule of expected cash disbursements for merchandise purchases for July, August, and September.

Schedule of Cash Disbursements for Purchases From accounts payable From July purchases From August purchases From September

July August September Quarter $84,000 $84,000 103,500 155,250 258,750 107,250 160,875 268,125 106,500 106,500

purchases Total cash disbursements

$187,500 $262,500

$267,375 $717,375

Prepare an income statement that computes net operating income for the quarter ended September 30.

Beech Corporation Income Statement For the Quarter Ended September 30 Sales $1,050,000 Cost of goods sold Gross margin Selling and administrative expenses Net operating income

787,500 262,500 132,000 130,500

Prepare a balance sheet as of September 30.

Beech Corporation Balance Sheet September 30 Assets Cash Accounts receivable Inventory Plant and equipment, net

Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings

Total liabilities and stockholders' equity Explanation

$219,125 227,500 69,375 205,000

$721,000 $159,750 349,000 212,250

$721,000

1. From July sales: 35% × $340,000 = $119,000 65% × $340,000 = $221,000

From August sales: 35% × $360,000 = $126,000 65% × $360,000 = $234,000

From September sales: 35% × $350,000 = $122,500

2. a. Desired ending merchandise inventory At July 31: $270,000 × 25% = $67,500. At September 30: $277,500 × 25% = $69,375.

3. Sales ($340,000 + $360,000 + $350,000) = $1,050,000 Cost of goods sold (Part 2a) = $787,500 Selling and administrative expenses ($44,000 × 3 months) = $132,000

4. Assets: Cash ($84,000 + $966,500 – $717,375 – ($38,000 × 3)) = $219,125 Accounts receivable ($350,000 × 65%) = $227,500 Inventory (Part 2a) = $69,375 Plant and equipment, net ($223,000 – ($6,000 × 3)) = $205,000

Liabilities and Stockholders’ Equity: Accounts payable ($266,250 × 60%) = $159,750 Common stock (Given) = $349,000 Retained earnings ($81,750 + $130,500) = $212,250

Exercise 8-14 Sales and Production Budgets [LO8-2, LO8-3] The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account): 1st Quarter2nd Quarter3rd Quarter4th Quarter Budgeted unit sales 11,300 12,300 14,300 13,300

The selling price of the company’s product is $12 per unit. Management expects to collect 75% of sales in the quarter in which the sales are made, 20% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $70,800. The company expects to start the first quarter with 1,695 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,895 units. Required:

1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole. 2. Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole. 3. Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole....