I dont even know where to start. Can you please tell me how to start it.

Out-West Products, Inc. Key Assumptions Unit Sales UNIT SALES Month TOTAL PID-B PID-P TOTAL Unit Volume Sensitivity --> April 7,650 7,650 7,650 ACTUAL May 8,400 8,400 8,400 June 9,200 7,360 1,840 9,200 0.0% FORECAST August September 11,400 12,700 8,550 9,017 2,850 3,683 11,400 12,700 July 10,200 7,956 2,244 10,200 October 13,200 9,240 3,960 13,200 PID-B PID-P 80% 20% 2% 78% 22% 3% 75% 25% 4% 71% 29% 1% 70% 30% Unit selling price PID-B PID-P $230 $380 -2.00% $225 $372 -2.00% $221 $365 -2.00% $216 $358 -2.00% $212 $350 Unit cost PID-B PID-P $155 $225 $155 $225 $155 $225 $155 $225 $155 $225 $260.00 $169.00 $257.74 $170.40 $256.91 $172.50 $257.42 $175.30 $253.65 $176.00 32.6% 40.8% 35.0% 31.2% 39.6% 33.9% 29.8% 38.3% 32.9% 28.4% 37.1% 31.9% 26.9% 35.8% 30.6% Sales Mix Sensitivity --> Sales Mix % Sales Price Sensitivity --> Weighted Average Sales Price Weighted Average Unit Cost Gross Profit % PID-B PID-P WTD AVG Other Assumptions Ending cash balance (per month) Ending inventory as percentage of next month's sales Percentage of purchases paid in: Current month Following month Percentage of sales collected in: Current month Following month Second following month New fixed asset purchases September Quarterly dividends Line-of-credit annual interest Balance Sheet: Actual as of June 30 Assets Cash & Equivalents Accounts Receivable May $579,600 units $40,000 75% 50% 50% 20% 50% 30% $100,000 $20,000 8% Operating expenses Variable: Sales commissions Shipping & handling Fixed: Wages and salaries Rent Utilities Insurance expired Depreciation Other S&A Advertising Campaign (% of sales) (per unit) 5.0% $15.00 (per month) $315,000 26,000 9,500 4,500 16,000 38,000 - OTHER INFO June $1,913,600 $47,000 2,493,200 Inventory 7,650 Prepaid insurance Fixed assets, net of depreciation Total Assets 1,292,850 20,000 1,480,000 $5,333,050 Liabilities and Stockholder's Equity Accounts payable, purchases Line-of-credit Dividends payable Capital stock, no par Retained earnings Total liabilities and stockholder's equity $889,075 20,000 1,750,000 2,673,975 $5,333,050 Scenario II_A_2C Oper Inc = LOC = #REF! Sensitivity II_C_2A Inv T/O = #VALUE! Sensitivity II_C_2B Days Sales = #VALUE! Out-West Products, Inc. Detailed Operating Schedules Schedule a: Sales plan Weighted average sales price July Total Units Credit sales, 100% NOTE: Actual A/R should be collected in July and Aug. Schedule b: Cash collections From current month's sales From sales 1 month before From sales 2 months before Total collections August $0 July July Schedule d: Purchases plan (dollars) Weighted average unit cost July September August September August $- $$0 July $0 - $0 Total September $- $0 0 0 Total $$0 September $0 - $0 1,196,000 1,297,200 $2,493,200 0 0 $$0 August $0 Total $0 $0 0 0 $- Total $0 $0 717,600 $717,600 0 0 Desired ending inventory Plus cost of goods sold Total requirements Less beginning inventory Total purchases Note: Actual A/P should be paid in July only Schedule e: Cash pmts for purchases From accounts payable (6/30) July August September Total payments $0 August $0 1,196,000 579,600 $1,775,600 Schedule c: Purchases plan in units Desired units in ending inventory Plus units sold Total needed Less beginning inventory Required purchases September $0 $0 $0 Total $0 $0 $0 $0 Out-West Products, Inc. Projected Income Statements and Balance Sheet Projected Income Statements Schedule Sales (a) Less variable expenses Cost of goods sold (d) Sales commissions Shipping & handling Total variable expenses Contribution margin Less fixed expenses Wages and salaries Rent Utilities Insurance expense Depreciation expense Other Selling & Admin. Advertising Campaign Total fixed expenses Operating Income Less: Interest Expense Net Income before Taxes July August September Total $0 - - - - - - - - 1,462 ($1,462) 2,147 ($2,147) 3,154 ($3,154) 6,763 ($6,763) Graph Data Weighted average computations: Sales price per unit Variable costs per unit $257.42 Weighted average unit cost Sales commissions Shipping and handling Total variable costs per unit $175.30 12.87 15.00 $203.17 Fixed costs in total - CVP Graph Data: Sales Levels Revenue Fixed Costs 0 $0 $0 5,000 $1,287,080 $0 10,000 $2,574,160 $0 15,000 $3,861,240 $0 20,000 $5,148,320 $0 25,000 $6,435,400 $0 30,000 $7,722,480 $0 Total Costs $0 $1,015,854 $2,031,708 $3,047,562 $4,063,416 $5,079,270 $6,095,124 instructions F O R M AT I O N S YS T EM S R I N G 20 13 I AL P L AN N I N G AN D M O D EL I N G C AS E GENERAL INSTRUC TIONS: READ THIS ENTIRE ASSIGN MENT CAR EF ULLY BEF ORE STARTING Y OUR W ORK. Fa ilure to follow the instructions wi ll result in point deduc tions. Projec ts not received by the due date wi ll receive a late penalty of 10 perc ent per day and a grade of z ero if more than 5 days late . Dow nlo ad al l fi les from the bl ackbo ard co urse pa ge, incl udi ng the acco mpan ying e xcel temp late, and sa ve th em. DO NOT C OPY AND PAST E T HE EXCEL TEMPLAT E INT O A NEW WORKBOOK AND DO NOT WOR K THR OUGH TH E WEB BR OWSER. Show a ll w ork and re lated co mputati ons to recei ve fu ll cred it. Use formul as in a ll sp read shee t cel ls and r efe rence g iven d ata cel ls as nece ssary. P OINTS WILL B E D EDU CTED F OR ENT ER ING H ARDCODED VALU ES. BE SURE T O REGU LARL Y SA VE YOUR WORK . Excuse s a bou t l ost w ork wil l not be acce pted. Ma intai n a seco nd (ba ckup) cop y o f you r fil e as wel l. CLEARL Y LABEL AND SUBMIT FILES OF THE \"BASELINE SCENAR IO\