Question

In: Accounting

Star Company manufactures swimming equipment used by divers. Management is now preparing detailed budget for July...

Star Company manufactures swimming equipment used by divers. Management is now preparing detailed budget for July and August, and has assembled the following information to assist in preparing the budget. (a) The Marketing Department has estimated sales as follows for the reminder of the year. The selling price of the equipment is $50 per unit. All sales are on account. July (Projected) 6,000 units August (Projected) 7,000 units September (Projected) 5,000 units October (Projected) 4,000 units (b) All sales are on account. Based on past experience, sales are expected to be collected in the following pattern: 40% in the month of sale 50% in the month following sale 10% uncollectable The beginning account receivable balance (including uncollectable amounts) on July 1 will be $120,000 (c) The desired ending finished goods inventory for each month is 10% of the following month’s sales. The inventory of finished goods on July 1 will be 600 units. (d) Each unit requires 2 kilograms of materials to produce. To prevent shortages, the company would like the inventory of this material on hand at the end of each month to be equal to 20% of the following month’s sales needs. Material costs are $2.50 per kilogram. Star Company pays for 60% of its purchases in the month of purchase, the remainder is paid for in the following month. The accounts payable balance for material purchases will be $11,400 on July 1. Required: Prepare the following for July and August (a) Production budget in units (b) Direct materials budget in kilograms and dollars (c) A schedule of expected cash collections (d) A schedule of expected cash disbursements for materials (e) How can sensitivity analysis be used to increase the benefits of budgeting? Explain

Solutions

Expert Solution

Desired production ending inventory = 10% of next month sales
Desired unit of material in Ending inventory = 20% of next month sales
Receipts from June
Accounts Receivable Balance on 1 July including uncollectibles = 120,000
60% of x = 120,000
x = $ 200,000
50% of x = $100,000


Related Solutions

Swanson, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets...
Swanson, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist in preparing the budget: a. The Marketing Department has estimated sales as follows for the remainder of the year (in pairs of swim fins). The selling price of the swim fins is $13 per pair.   July 5,600   October 3,600   August 6,600   November 2,600   September 4,600   December 2,600 b. All...
Omar Inc. manufactures an advanced swim fin for scurba divers. Management is now preparing detailed budgets...
Omar Inc. manufactures an advanced swim fin for scurba divers. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist in preparing the budget. The marketing department has estimated sales in units as follows for the remainder of the year. June 6,500 July 5,400 August 7,200 September 4,600 October 3,800 1. The selling price of the swim fins is $35 per pair. 2. All sales are on account. Based...
Swanson, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets...
Swanson, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist in preparing the budget: a. The Marketing Department has estimated sales as follows for the remainder of the year (in pairs of swim fins). The selling price of the swim fins is $17 per pair.   July 6,000   October 4,000   August 7,000   November 3,000   September 5,000   December 3,000 b. All...
Swanson, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets...
Swanson, Inc., manufactures an advanced swim fin for scuba divers. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist in preparing the budget: a. The Marketing Department has estimated sales as follows for the remainder of the year (in pairs of swim fins). The selling price of the swim fins is $21 per pair. July 6,400 October 4,400   August 7,400 November 3,400   September 5,400 December 3,400   b. All...
Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter...
Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units):   July 37,000   October 27,000   August 77,000   November 17,000   September 57,000   December 17,000 The selling price of the beach umbrellas is $10 per unit. Sales in June were 32,000 units. b. All sales are on account....
Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter...
Milo Company manufactures beach umbrellas. The company is now preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: a. The Marketing Department has estimated sales as follows for the remainder of the year (in units):   July 46,000   October 36,000   August 86,000   November 26,000   September 66,000   December 26,000 The selling price of the beach umbrellas is $12 per unit. Sales in June were 41,000 units. b. All sales are on account....
Wolfpack Company is a merchandising company that is preparing a budget for the month of July....
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 75,000 Accounts receivable 58,600 Inventory 43,000 Buildings and equipment, net of depreciation 205,000 Total assets $ 381,600 Liabilities and Stockholders’ Equity Accounts payable $ 68,600 Common stock 100,000 Retained earnings 213,000 Total liabilities and stockholders’ equity $ 381,600 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July....
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 77,000 Accounts receivable 58,200 Inventory 32,800 Buildings and equipment, net of depreciation 186,000 Total assets $ 354,000 Liabilities and Stockholders’ Equity Accounts payable $ 39,000 Common stock 100,000 Retained earnings 215,000 Total liabilities and stockholders’ equity $ 354,000 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July....
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 91,400 Accounts receivable 67,200 Inventory 31,000 Buildings and equipment, net of depreciation 165,000 Total assets $ 354,600 Liabilities and Stockholders’ Equity Accounts payable $ 62,600 Common stock 100,000 Retained earnings 192,000 Total liabilities and stockholders’ equity $ 354,600 Budgeting Assumptions: 1. All sales are on account. Thirty percent of...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July....
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 91,400 Accounts receivable 55,600 Inventory 48,800 Buildings and equipment, net of depreciation 237,000 Total assets $ 432,800 Liabilities and Stockholders’ Equity Accounts payable $ 32,800 Common stock 100,000 Retained earnings 300,000 Total liabilities and stockholders’ equity $ 432,800 Budgeting Assumptions: All sales are on account. Thirty percent of the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT