Water Sport Inc. manufactures a small personal water tube used for children learning to swim. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist:
a. The Marketing Department has estimated sales as follows for the
remainder of the year (number of water tubes):
July | 7,300 | October | 3,700 |
August | 5,800 | November | 3,300 |
September | 4,800 | December | 2,800 |
The selling price of the water tubes is $60.
b. All sales are on account. Based on past experience, sales are
expected to be collected in the following pattern:
50 | % | in the month of sale |
45 | % | in the month following sale |
5 | % | uncollectible |
The beginning accounts receivable balance (excluding uncollectible amounts) on July 1 will be $164,000.
SALES AND CASH COLLECTION BUDGET | ||||||||||
July | August | September | October | November | December | |||||
A | Sales in Units | 7,300 | 5,800 | 4,800 | 3,700 | 3,300 | 2,800 | |||
B=A*$60 | Sales Revenue | $438,000 | $348,000 | $288,000 | $222,000 | $198,000 | $168,000 | |||
C=B*50% | Collection from the month of Sales | $219,000 | $174,000 | $144,000 | $111,000 | $99,000 | $84,000 | |||
D | Collection from previous month of Sales(45%) | $164,000 | $197,100 | $156,600 | $129,600 | $99,900 | $89,100 | |||
E=C+D | Total Cash Collection during the month | $383,000 | $371,100 | $300,600 | $240,600 | $198,900 | $173,100 | |||
Collection in August from July Sales = | $197,100 | 45%*438000 | ||||||||
Collection in July from Previous Sales = | $164,000 | Accounts Receivable | ||||||||
PRODUCTION BUDGET | ||||||||||
July | August | September | October | November | December | |||||
A | Sales in Units | 7,300 | 5,800 | 4,800 | 3,700 | 3,300 | 2,800 | |||
B | End of Month inventory | 1,160 | 960 | 740 | 660 | 560 | ||||
C | Beginning of Month Inventory | 1,460 | 1,160 | 960 | 740 | 660 | 560 | |||
D=A+B-C | Budgeted Production in units | 7,000 | 5,600 | 4,580 | 3,620 | 3,200 | ||||
End of Month inventory in July =20%*5800 | 1,160 | |||||||||
Beginning of month inventory in July | 1,460 | |||||||||
DIRECT MATERIALS PURCHASE BUDGET | ||||||||||
July | August | September | October | November | ||||||
A | Budgeted Production in units | 7,000 | 5,600 | 4,580 | 3,620 | 3,200 | ||||
B=A*3 | Raw materials required (Kilograms) | 21,000 | 16,800 | 13,740 | 10,860 | 9,600 | ||||
C | End of month inventory(Kilograms) | 3,360 | 2,748 | 2,172 | 1,920 | |||||
D | Beginning of months inventory(Kilograms) | 4,200 | 3,360 | 2,748 | 2,172 | |||||
E=B+C-D | Budgeted direct material purchase(Kilograms) | 20,160 | 16,188 | 13,164 | 10,608 | |||||
F=E*$3 | Budgeted direct material purchase(Dollars) | $60,480 | $48,564 | $39,492 | $31,824 | |||||
End of months inventory in July =20%*16800= | 3,360 | |||||||||
Beginning of months inventory in July | 4,200 | |||||||||
PURCHASE DISBURSEMENT BUDGET | ||||||||||
July | August | September | October | |||||||
A | Budgeted direct material purchase(Dollars) | $60,480 | $48,564 | $39,492 | $31,824 | |||||
B=A*70% | Payment for the month of purchase | $42,336 | $33,995 | $27,644 | $22,277 | |||||
C | Payment for previous months purchase | $13,800 | $18,144 | $14,569 | $11,848 | |||||
D=B+C | Budgeted Purchase Disbursement | $56,136 | $52,139 | $42,214 | $34,124 | |||||
Payment in August for July Purchase=30%*60480 | $18,144 | |||||||||
Payment in July for Previous Purchase | $13,800 | Accounts Payable | ||||||||
Water Sport Inc. manufactures a small personal water tube used for children learning to swim. Management...
Water Sport Inc. manufactures a small personal water tube used for children learning to swim. Management is now preparing detailed budgets for the third quarter, July through September, and has assembled the following information to assist: a. The Marketing Department has estimated sales as follows for the remainder of the year (number of water tubes): July August September 7,400 October 5,900 November 4,900 December 3,800 3,400 2,900 The selling price of the water tubes is $60. b. All sales are...
crossed out requirements not needed PROBLEM 7-20B Integration of Sales, Production, and Direct Materials Budgets [LO2, LO3, LO4] CHECK FIGURE (1) August collections: $71,838 (3b) August payments: $59,572 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...
Question 6 (12 marks) Kohli Cricket Equipment Ltd manufactures cricket bats. Management is now preparing detailed budgets for the third quarter, July to 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 July August September August 12,000 14,000 10,000 October November December 8,000 6,000 6,000 • The company maintains finished goods inventories equal to 10% of the following month's sales....
The Marketing Department has estimated sales as follows for the remainder of the year (in units): July42,500October32,500August95,000November19,000September64,000December19,500 The selling price of the beach umbrellas is $10 per unit.All sales are on account. Based on past experience, sales are collected in the following pattern: 30%in the month of sale65%in the month following sale5%uncollectible Sales for June totaled $440,000.The company maintains finished goods inventories equal to 15% of the following month’s sales. This requirement will be met at the end of June.Each beach umbrella requires 4...
The Marketing Department has estimated sales as follows for the remainder of the year (in units): July42,500October32,500August95,000November19,000September64,000December19,500 The selling price of the beach umbrellas is $10 per unit.All sales are on account. Based on past experience, sales are collected in the following pattern: 30%in the month of sale65%in the month following sale5%uncollectible Sales for June totaled $440,000.The company maintains finished goods inventories equal to 15% of the following month’s sales. This requirement will be met at the end of June.Each beach umbrella requires 4...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 35,500 October 25,500 August 81,000 November 12,000 September 50,000 December 12,500 The selling price of the beach umbrellas is $14 per unit. All sales are on account. Based on past experience, sales are collected in the...
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 33,000 October 23,000 August 73,000 November 13,000 September 53,000 December 13,000 The selling price of the beach umbrellas is $10 per unit. Sales in June were 28,000 units. b. All sales are on account....
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units):July35,500October25,500August81,000November12,000September50,000December12,500The selling price of the beach umbrellas is $14 per unit.All sales are on account. Based on past experience, sales are collected in the following pattern: 30%in the month of sale65%in the month following sale5%uncollectible Sales for June totaled $420,000.The company...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 40,500 October 30,500 August 91,000 November 17,000 September 60,000 December 17,500 The selling price of the beach umbrellas is $12 per unit. All sales are on account. Based on past experience, sales are collected in the...
Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation: The Marketing Department has estimated sales as follows for the remainder of the year (in units): July 38,000 October 28,000 August 86,000 November 14,500 September 55,000 December 15,000 The selling price of the beach umbrellas is $13 per unit. All sales are on account. Based on past experience, sales are collected in the...