Winnie's Wearable Masks Projected Budgeting Data JULY 222,000 7.75 AUGUST 290.000 2020 SEPTEMBER 216.000 OCTOBER 165,000 NOVEMBER 197,000 $ Sales: Sales in Units (Masks) Selling Price per Mask Collections: Cash Collected in the Month of Sale Cash Collected in Following Month Finished Goods Inventory: Ending FG Inventory Requirement Beginning FG Inventory, July 1, 2020 7096 3096 20% of next month's unit sales 44.400 masks Raw Materials Inventory: Raw Materials Required per Mask Raw Materials Cost per Yard Ending RM Inventory Requirement Paid in Month of Purchase Paid in Following Month Beginning RM Inventory, July 1, 2020 Direct Labor: Labor Required per Mask Labor Cost per Hour 0.2 yards of fabric $14.00 per yard 30% of next month's production needs 60% 40% 14,136 yards of fabric 0.05 hours 18.00 per hour Manfacturing Overhead: Variable OH Fixed OH Noncash Fixed OH (included in above) $ $ 0.75 per mask 114.000 per month 22,000 per month Selling & Administrative Expenses: Variable S&A Fixed S&A Noncash Fixed S&A (included in above) $ $ $ 1.35 per unit sold 65,000 per month 9,000 per month Other: Equipment Purchase $ 68,000 purchased on July 1, 2020 'depreciation is already included in noncash fixed OH above Cash Borrowings: Interest Payment Repayment $ $ 5,250 per month until repayment occurs 700.000 at the end of August TOTAL October Raw Materials Purchases Budget 2020 July August September Units Produced Yards of RM Required Per Unit of FG Total Yards Used in Production Plus: Desired Yards in Ending Inventory Total Yards Required Less: Yards in Beginning Inventory RAW MATERIALS PURCHASES (YARDS) Cost per Yard RAW MATERIALS PURCHASES (COST)