| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Comfort Manufactoring | |||||||||||
2 | Budget Information Sheet- Teddy Bears/ Pillows | |||||||||||
3 | For the Year Ending 31 December 2014 | Sales Cycle | Production | Cycle | ||||||||
4 | Teddy Bears | Pillows | Teddy Bears | Pillows | Teddy Bears | Pilliows | ||||||
5 | Budget Sales Price, 2014 | $35.00 | $30.00 | Jan | 0.1 | 0.025 | Jan | 0.15 | 0.05 | |||
6 | Feb | 0.15 | 0.025 | Feb | 0.15 | 0.05 | ||||||
7 | Budgeted Annual Sales, Units | 243,000 | 610,000 | Mar | 0.075 | 0.025 | Mar | 0.025 | 0.1 | |||
8 | Apr | 0.05 | 0.075 | Apr | 0.05 | 0.15 | ||||||
9 | Budgeted Annual Production, Units | 240,000 | 600,000 | May | 0.025 | 0.125 | May | 0.05 | 0.15 | |||
10 | June | 0.025 | 0.15 | June | 0.025 | 0.15 | ||||||
11 | Product Specifications Per Unit: | July | 0.025 | 0.15 | July | 0.02 | 0.1 | |||||
12 | Brown Teddy Bears: | Aug | 0.05 | 0.15 | Aug | 0.045 | 0.1 | |||||
13 | Direct Materials: | Sept | 0.1 | 0.15 | Sept | 0.078 | 0.05 | |||||
14 | Stuffing (ounces) | 8 | Oct | 0.15 | 0.075 | Oct | 0.167 | 0.05 | ||||
15 | Bear Bodies | 1 | Nov | 0.1 | 0.025 | Nov | 0.14 | 0.025 | ||||
16 | Dec | 0.15 | 0.025 | Dec | 0.1 | 0.025 | ||||||
17 | Direct Labor(Minutes): | Total: | 1 | 1 | Total: | 1 | 1 | |||||
18 | Stuffing | 1 | ||||||||||
19 | Finsihing | 1.5 | ||||||||||
20 | ||||||||||||
21 | Firm Pillows: | |||||||||||
22 | Direct Materials: | |||||||||||
23 | Stuffing (ounces) | 16 | ||||||||||
24 | Pillow Shells | 1 | ||||||||||
25 | ||||||||||||
26 | Direct Labor(Minutes): | |||||||||||
27 | Stuffing | 1 | ||||||||||
28 | Sewing | 1 | ||||||||||
29 | ||||||||||||
30 | Inventory, Units | |||||||||||
31 | Dirtect Material: | Beg Inv (Jan) | End Inv (Dec) | Minimum | Bear Stuffing Beg Inv | Pillow Beg Inv | Bear Stuffing End Inv | Pillow Stuffing End Inv | Bear Stuffing Min | Pillow Stuffing Min | ||
32 | Stuffing(ounces) | 268,800 | 84,800 | 16,192 | 134400 | 134400 | 42400 | 42400 | 8096 | 8096 | ||
33 | Bear Bodies | 3,600 | 600 | 24 | ||||||||
34 | Pillow Shells | 15,000 | 5,000 | 1,000 | ||||||||
35 | Finished Goods: | |||||||||||
36 | Teddy Bears | 3,600 | 600 | |||||||||
37 | Pillows | 15,000 | 5,000 | |||||||||
38 | ||||||||||||
39 | Teddy Bear Cost Assumptions: | 2014 | 2015 | |||||||||
40 | Stuffing (per ounce) | $0.20 | $0.16 | |||||||||
41 | Teddy Bears | $4.50 | $4.75 | |||||||||
42 | Stuffing Labor, per hour | $9.00 | $10.00 | |||||||||
43 | Finishing Labor, per hour | $8.00 | $9.00 | |||||||||
44 | Per unit cost of Brown Teddy Bears: | $7.00 | $8.96 | |||||||||
45 | ||||||||||||
46 | Pillow Cost Assumptions: | 2014 | 2015 | |||||||||
47 | Stuffing (per ounce) | $0.20 | $0.16 | |||||||||
48 | Pillow Shells | $1.00 | $0.90 | |||||||||
49 | Stuffing Labor, per hour | $9.00 | $10.00 | |||||||||
50 | Sewing Labor, per hour | $7.25 | $7.50 | |||||||||
51 | Per unit cost of Firm Pillows: | $5.00 | $5.79 | |||||||||
52 | ||||||||||||
53 | Non-Manufacturing Costs: | Variable | Fixed | |||||||||
54 | R&D, Product Design | 0.025 | $140,000 | |||||||||
55 | Marketing | 0.05 | 600,000 | |||||||||
56 | Distribution | 0.02 | 200,000 | |||||||||
57 | Customer Service | 0.015 | 100,000 | |||||||||
58 | Administrative | 0.014 | 250,000 | |||||||||
59 | Totals | 0.124 | $1,290,000 | |||||||||
60 | ||||||||||||
61 | Fixed Manufacturing Overhead: | Total | Allocation, per DMLH | |||||||||
62 | Depreciation | $200,000 | $6.67 | |||||||||
63 | Property Taxes | 150,000 | 5 | |||||||||
64 | Property Insurance | 120,000 | 4 | |||||||||
65 | Plant Supervision | 90,000 | 3 | |||||||||
66 | Miscellaneous | 150000 | 5 | |||||||||
67 | Total Fixed Manufacturing Overhead | $710,000 | $23.67 | |||||||||
68 | ||||||||||||
69 | Variable Manufacturing Overhead: | Total | Allocation, per DMLH | |||||||||
70 | Supplies | $260,000 | $8.67 | |||||||||
71 | Indirect Labor | 60,000 | 2 | |||||||||
72 | Power & Energy | 340,000 | 11.33 | |||||||||
73 | Maintenance | 310,000 | 10.33 | |||||||||
74 | Miscellaneous | 150,000 | 5 | |||||||||
75 | Total Vaiable Manufacturing Overheard | $1,120,000 | $37.33 | |||||||||
76 | ||||||||||||
77 | ||||||||||||
78 | Inventory Cost-Flow Method: | |||||||||||
79 | Number of Full-time production employees: 12 | |||||||||||
80 | No overtime hours that are allowed; 40 hours a week | |||||||||||
81 | Emloyess are allowed to two weeks' vacation; 50 weeks a year | |||||||||||
82 | All our labor and materials cost are on annual contracts | |||||||||||
83 | No WIP inventory allowed | |||||||||||
84 | Production peak varies to sales peak | |||||||||||