Quarterly Sales Budget by Districts; Inventory Schedule. Estimated sales for the first three-month 1 answer below »
Quarterly Sales Budget by Districts; Inventory Schedule. Estimated sales for the first three-month period of the coming year of the Swartz Company are:
District Jan.
% Feb.
% March
% Total
%
Maine
.
50
30
20
100
New Hampshire
.
55
30
15
100
Vermont
.
50
25
25
100
Massachusetts
.
50
25
25
100
Estimated unit sales by districts for the three months are:
District
Maine . New Hampshire . Vermont . Massachusetts .
Total .
Unit
Sales
20,000
30,000
10,000
40,000
100,000
The unit sales price is $2.
Company policy expects an inventory of 10,000 units at the beginning and the end of each three-month period. The production schedule is:
January. . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . 55% February. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30% March…………………………. ……………•…… 15%
Required: (1) An estimate of sales by units and dollars for each of the first three months for each district and in total.
(2) A schedule of the end-of-month inventories by units. The beginning inventory is 10,000 units.