70.2K

Verified Solution

Link Copied!

check figures for the assignment

Cost of Goods Sold 2025 - 372,208.84

Total Administrative Expenses 2026 - 154,660.00

Operating Income 2027 - 1,112,981.54

2. Use the sales figure of $1,600,950 for 2023 . - Management predicts that revenue will increase by 2.8% each year. - Use absolute cell referencing. 3. Cost of goods sold is 22% of sales for each year. - Use a range name for cost of goods sold (COGS). 4. Advertising expense will be 3.0% of sales for each year. - Use a range name for advertising expense (advertising_exp). 5. Commission expense will be 4.1% of sales for each year. - Use a range name commission expense (commission_exp). 6. Calculate total selling expenses. 7. Administrative Expenses will be the same during 2023-2025. - All Administrative Expenses increase by 10.0% in the year 2026. - Use numbers from the Administrative Expenses chart. - Use absolute cell referencing. 8. Find total administrative expenses. 9. Calculate total operating expenses. 10. Calculate operating income. 11. Enter a formula to show "Yes" if operating income is more than $1,045,800 for each year. - If operating income is not more than $1,045,800, then show "No" as the result. - Use an IF statement. - Use absolute cell referencing for the target amount, labeled "Target Amount" on the templa 12. Create a clustered column chart for gross profit for 2023-2027. - Use a chart title (Computer Sales and Service 2023-2027). - Include a legend (Gross Profit). - Label the xaxis, years 2023-2027. - The chart should not include Gross Profit Total. 13. Create a header to include your name and INFS 3100 Summer 2023. - Use the header function. Cempuner Sales and Senice Polected lincome Sunement 2023 \% 2027 - This is a beade with no comepending caloulaben en this new. inden Graph Here

Answer & Explanation Solved by verified expert

See Answer