Basic Sandals Deluxe Sandals Unit Sales Forecast 2,000 3.000 (No. of Pairs of Sandals) Unit Sales Price 120.00 195.00 Beginning Finished Goods Inventory 250 650 (No. of Pairs of Sandals) Cost of Beg. FG Inv. 23.250.00 92.625.00 Ending Finished Goods Inventory 400 600 (No. of Pairs of Sandals) Beginning Direct Material Inventories: Cloth (in yds) 610.00 [Yds of Cloth) Wood (in Bd-ft) 800.00 (Bd-ft of Wood) Cost of Cloth in Beginning Inventory 3.219.00 Cost of Wood in Beginning Inventory 6.060.00 June Direct Material Purchase Prices Cloth 5.25 (per yd of cloth) Wood 7.50 per bd-ft of wood Ending Direct Material Inventories: Cloth (in yds) 386.00 [Yds of Cloth) Wood (in bd-ft) 295.00 (Bd-ft of Wood Oty of Cloth required to make one pair of sandals .30 1.50 (Yds of Cloth) Qty of Wood required to make one pair of sandals 0.00 2.00 Bd-ft of Wood) Direct Labor Hours per pair of sandals 5.00 7.00 (Direct Labor Hours) Direct Labor Rate 15.00 (DL$/DLHr) Mig Batch Size 50.00 50.00 (Pairs of Sandals per batch) Setup Hours per mfg batch 2.00 3.00 (Setup Hours) Mig OH - Setup cost 18.00 (=/Setup Hour Mfg OH - Processing cost 1.80 (F/DLHr) Mig OH - Inspection cost 1.35 (#/Pair of Sandals) Marketing and General Administration 8.00%% (of June revenues) Shipment Batch Size 40.00 40.00 Pairs of Sandals per batch) Shipping cost 15.00 (per shipment) Credit Sales 100.00% (of Revenues) Credit Sales Collected in Month of Sale 60.009% [(of Credit Sales) Credit Sales Collected in Month Following Month of Sale 38.009% (of Credit Sales) Credit Sales Uncollectable 2.00%% (of Credit Sales) DM Purchases paid in month of purchase 80.009% (of DM purchases) Portion of Mig OH that is depreciation 30.009% (of Processing and Setup) Portion of Non-Mig OH that is depreciation 10.009% (of Marketing & General Administration) Annual interest rate on long term debt 6.00%% (APR) Dividend declared and paid 15,000.00 May 31. 2012 Balance Sheet amounts Cash 9.435.00 Accounts Receivable, ne 824.000.00 Allowance for Bad Debts 16,200.00 Fixed Assets 0.00 Accumulated Depreciation 136,3 5.00 Accounts Payable 15,600.00 Taxes Payable 10,800.00 Interest Payable 750.00 Long Term Debt 150,000.00 Common Stock 300,000.00 Retained Earnings 698.904.00 Results: Total Revenues $ 825,000.00 Units to be Produced Total cost of direct materials to be used (Total) Direct materials purchase costs Total Direct manufacturing labor Mig OH - Machine Setup Costs Mig OH - Processing Costs Mig OH - Inspection Ending Direct Materials Inventory Ending Finished Goods inventory Cost of goods sold Marketing and General Administrative costs Shipping costs Month ending June - Total cash available for needs June 30 ending cash balance Net Income Month ending June 30 Total Assets