Solve please

File Paste Home Insert Arial Draw Page Layout Font Formulas Data Review View Automate ab ce Wrap Text Merge & Center Help General .00 clipboard E33 Alignment Number c Conditional Format as Cell Formatting v Table v Styles Styles D REVENUE ASSUMPTIONS: Selling price of silk-screened shirts Estimated number of shirts to be sold in the first five quarters: First quarter year 1 Second quarter year 1 Third quarter year 1 Fourth quarter year 1 First quarter year 2 10 12 13 14 15 16 17 18 19 18.00 8,000 10,ooo 20,000 i2,ooo 18,000 9.00 11 -oo 0.12 7500 690.00 question4 MORE COST ASSUMPTIONS: Cary Sue's compensation: Monthly salary Percentage commission of sales Amount of workday focusing on sales Amount of workday spent on clerical and administrative duties Graphic designer costs: Monthly cost Per shirt cost Building rental: Monthly rent of building Percent of building used for silk-screening process Percent of building used for sales and adminstrative duties Other costs. Cost of ink used in the silk-screen process (per shirt) Weekly advertising cost Annual property taxes and insurance on machinery Insen Delete Format Cells 1 ,ooo-oo 500.00 0.10 1 ,200-oo 750/01 075 10000 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Schedule of collections: Cash collected in the quarter of the sale Cash collected in the quarter following the sale COST ASSUMPTIONS: Purchasing assumptions: Cost per sweatshirt purchased Desired ending inventory of shirts as a percent of the next quarter's sales Schedule for payment of sweatshirts: To be paid in the quarter of purchase To be paid in the quarter following the purchase Direct labor costs: Hourly wage rate to pay college workers Silk-screening labor hours per shirt Depreciation expense: Selling and administrative equipment quarterly depreciation Production equipment quarterly depreciation HINTS/TIPS: Four quarters in a year- Yearly amount / 4 = quarterly amount. Thirteen weeks in a quarter- Weekly amount * 13 = quarterly amount- INPUTS Grading 'questionl question2 question3 Annual property tax and insurance on display furniture and cash register Utilities cost per shirt Maintenance cost per shirt Utilities monthly fixed cost Maintenance monthly fixed cost Other items: Total equipment cost to be paid in quarter 1 and quarter 2 Desired loan amount Interest rate on loan Income tax rate $ 2,24000 $ 380.00 005 0033 $1 ,ooo.ooo $ 8,675.00 $20,000.00 question5 question6 questiot Ready Accessibility: Unavailable