Old MathJax webview

Old MathJax webview

Old MathJax webview

J K L M O F G H Production Information: Raw Materials (per unit): BBU 3 EBJ 3.25 1 27 Fabric (Yards) Zippers/Rivets (Sets) Embroidery Thread (Yards) Embellishments (Sets) 1 JBJ RM Cost/Unit 3.5 $6.00 per yard 1 $1.25 per set 3 $0.03 per yard 1 $8.00 per set 3 0 0 Payables Information: 40% of direct materials are paid in the quarter of sale 60% are paid in the following quarter Direct Labor (per unit): Time in Minutes BBJ EB) 11 12 5 7 14 Cutting Embroidery Embellishing Assembly JBJ DL Cost/Hour $18.00 9 $22.00 19 $26.00 8 $15.00 0 0 LO 6 00 A/R 52 20 EB) Overhead: Applied on the basis of Machine Hours BBJ Cutting time in minutes 8 Assembly time in minutes 5 JBJ 13 9 10 8 Inventory to keep on hand: Finished goods: Raw Materials: 15% of next quarter's sales projection 25% of next quarter's production requirements OLE DUEL 2018 03 01 Q2 04 TOTAL Formula Hints 2019 01 24,080 17,371 10,857 Note: Hide these rows when budget is completed Budgeted production (in units) comes from the data calculated on the Production sheet. To get direct materials, multiply the amounts of raw materials for each of the 3 products times the production for each from rows 4:6. Then, add together to get the total. 166,694 52,308 573,824 10,857 Value of Expected Note: hide this column when budget is $ 380,699 complete This section uses the target percent for raw materials inventory from the Data Input sheet multiplied by the values from rows 9:12 above as appropriate for the upcoming quarter. This section uses the target percent for raw materials inventory from the Data Input sheet multiplied by the values from rows 9:12 above as appropriate for the current quarter. . Remember to multiply by 1 or add a-symbol). 2 3 3 4 BBJ Production in units 5 EBI Production in units 6 JBJ Production in units 7 8 Direct Materials Needed 9 Fabric (Yards) 10 Zippers/Rivets (Sets) 11 Embroidery Thread (Yards) 12 Embellishments (Sets) 13 14 Plus Desired Ending Inventory 15 Fabric (Yards) 16 Zippers/Rivets (Sets) 17 Embroidery Thread (Yards) 18 Embellishments (Sets) 19 20 Less Planned Beginning Inventory 21 Fabric (Yards) 22 Zippers/Rivets (Sets) 23 Embroidery Thread [Yards) 24 Embellishments (Sets) 25 26 Direct Materials to be purchased 27 Fabric (Yards) 28 Zippers/Rivets (Sets) 29 Embroidery Thread [Yards) 30 Embellishments (Sets) 31 32 Cost of Materials to be purchased 33 Fabric (Yards) 34 Zippers/Rivets (sets) 35 Embroidery Thread [Yards) 36 Embellishments (sets) 37 Total Cost 38 39 Schedule of Cash Payments 40 Beginning A/P 41 Purchases from 1 42 Purchases from Q2 43 Purchases from Q3 44 Purchases from 04 45 46 47 48 Proof 49 50 51 This section sums the three sections above it. 347,547 270,052 2,405,538 41,546 This section multiplies the totals frows 27:30) times the cost per raw material type from the Data Input worksheet. Q2 01 04 Remaining A/P TOTAL This section is similar to the A/R collections schedule on the sales sheet. Use the Payables percentage values from the Data input sheet. The Remaining A/P cells (column H) is an optional check sale for rows 48:50 below. $ 6,006,782 Total Purchases Bea AP Total Collections 1 A Ending A/P Note: Hide these rows and columns when budget is completed The Beginning A/P (or accounts payable) value comes from the ending balance sheet for the prior fiscal year. Find that balance sheet on the Data input sheet, columns W:Z 2018 Q3 Q2 01 04 Q2 TOTAL Q1 43,059 Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Required Production 39,000 5,967 44,967 (5,850) 39,117 39,780 6,086 45,866 (5,967) 39,899 40,576 6,208 46,784 (6,086) 40,697 41,387 6,332 47,719 (6,208) 41,511 160,743 24,594 185,336 (24,111) 161,225 42,215 6,459 48,674 (24,594) 24,080 BJ: 17,665 Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Required Production 16,000 2,448 18,448 (2,400) 16,048 16,320 2,497 18,817 (2,448) 16,369 16,646 2,547 19,193 (2,497) 16,696 16,979 2,598 19,577 (2,547) 17,030 65,946 10,090 76,035 (9,892) 66,144 17,319 2,650 19,969 (2,598) 17,371 BJ: 11,041 Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Required Production 10,000 1,530 11,530 (1,500) 10,030 10,200 1,561 11,761 (1,530) 10,231 10,404 1,592 11,996 (1,561) 10,435 10,612 1,624 12,236 (1,592) 10,644 41,216 6,306 47,522 (6,182) 41,340 10,824 1,656 12,480 (1,624) 10,857 Note: hide these columns when budget is completed SCF ... Data Input Sales Producton DM DL MOH Unit Costs SellAdmin Cash Budget Inc.Stmt. BalSheet Average: 10,335 Count: 4 s