1. Royal Company is preparing budgets for the second quarter ending June 30. Last year's sales for the corresponding period were: March 15,000 units April 18,000 units May 28,000 units June 26,000 units July 19,000 units August 12,000 unit.
The company expects this year's sales to increase by 25%. The selling price is $13 per unit. Prepare a Sales Budget for Royal Company.
Sales Budget
Particulars | March | April | May | June | July | August | Quarter |
Budgeted Sales in Units | $ 15,000 | $18,000 | $28,000 | $26,000 | $19,000 | $12,000 | $118,000 |
Selling Price | $13 | $13 | $13 | $13 | $13 | $13 | $13 |
Total Sales | $195,000 | $234,000 | $364,000 | $338,000 | $247,000 | $156,000 | $1,534,000 |
1. Royal Company is preparing budgets for the second quarter ending June 30. Last year's sales...
Royal Company is preparing budgets for the second quarter ending June 30. Last year's sales for the corresponding period were: A. The company expects this year's sales to increase by 25%. The selling price is $13 per unit. Prepare a Sales Budget. B. The company desires to have finished inventory on hand at the end of each month equal to 30 percent of the following month's budgeted unit sales. On March 31, there were 3,000 units on hand. Prepare a...
Thunder Creek Company is preparing budgets for the first quarter of 2018. All relevant information is presented on the Excel template. Prepare a sales budget. (18 pts) Thunder Creek Company expects sales of 18,000 units in January 2018, 24,000 units in February, 30,000 units in March, 34,000 in April, and 36,000 in May. The sales price is $34 per unit.
Milo Company manufactures beach umbrelas. The company is 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) The selling price of the beach umbrellas is $13 per unit uly 35,000 October 25,000 11.500 12.000 August September 80.000 49,000 November December b. All sales are on account. Based on past experience, sales are collected...
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 August September 31,000 October 71,000 November 51,000 December 21,000 11,000 11,000 The selling price of the beach umbrellas is $10 per unit. Sales in June were 26,000 units. b. All sales are on account....
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): 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...
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): 32,000 22,000 22,000 42,000 October 82,000 62,000 December July August September November The selling price of the beach umbrellas is $12 per unit. Sales in June were 37,000 units. b. All sales are on account....
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) 33,000 23,000 23,000 43,000 October 83,000 November 63,000 December July August September The selling price of the beach umbrellas is $10 per unit. Sales in June were 38,000 units b. All sales are on account....
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): 44,000 October 84,000 November 64,000 December July August September 34,000 24,000 24,000 The selling price of the beach umbrellas is $12 per unit. Sales in June were 39,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): 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...