Question

Master Budget Case: Wooden Pull Toys Inc. Wooden Pull Toys Ltd. is a company that manufactures and sells a single product, which they call a Baby Turtle. For planning and control purposes they utilize a quarterly master budget, which is usually developed at least six months in advance of the budget period. Their fiscal year end is December 31. During the summer of 2019, Jimmy C., the Wooden Pull Toys controller, spent considerable time with Fanny L., the Manager of Marketing, putting together a sales forecast for the first quarter of next year (January to March, 2020). Unfortunately, their collaboration worked so well they eloped to Niagara, ON, were married and settled down. Prior to their departure they e-mailed letters of resignation and a cryptic sales forecast to the President of Wooden Pull Toys. Their sales forecast consisted of these few lines: • For the year ended December 31, 2019: 475,000 units at $11.00 each* • For the year ended December 31, 2020: 500,000 units at $11.00 each • For the year ended December 31, 2021: 500,000 units at $11.00 each *Expected sales for the year ended December 31, 2019 are based on actual sales to date and budgeted sales for the duration of the year. Wooden Pull Toys’ President felt certain that the marriage wouldn’t last, and expected Chris would be back any day. But the end of the year is quickly approaching, and there is still no word from the desert. The President, desperately needing the budget completed, has approached you, a management accounting student, for help in preparing the budget for the first quarter. Your conversations with the President and your investigations of the company’s records have revealed the following information: 1. Sales of Baby Turtles are seasonal. History shows that January, March, May and June are the slowest months with only 5% of sales for each month. Sales pick up over the summer with July, August and September each contributing 6% to the total. Valentines Day in February boosts sales to 10%, and spring break in April accounts for 7%. As Christmas shopping picks up momentum, winter sales start at 10% in October, move to 15% in November and then peak at 20% in December. This pattern of sales is not expected to change in the next two years.

Answer 1

President asked us to present budget for the first quarter thus

Budget for Quarter 1 2020
Month	% of sales	Quantity	Rate ($)	Amount ($)
January	5	25000	11	275000
February	10	50000	11	550000
March	5	25000	11	275000
Total	20	100000	33	1100000

Quantity =Expected Sales * % of sales i.e 500,000 units * % of sales.