Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

M N Typical Income Statement for Manufacturing Business Final Probl). The model to the right is a very simple Income/Loss Statement for a manufacturing business.

image text in transcribed
M N Typical Income Statement for Manufacturing Business Final Probl). The model to the right is a very simple Income/Loss Statement for a manufacturing business. There are many simplifications in this model, but an Income/Loss Statement is a very useful tool for analyzing profitability when numerous variables need to be considered. The model assumes that the variable values are known (deterministic), but this does not restrict the user from asking numerous important "What if" questions. You can determine the model's assumptions by examining the cells where calculations take place...& notice the parameters in Column N used in the calculations. Revenue 9.000.00 COGS 360000 Gross Profit 540000 04 CC00% 03 s Var.Cost Variable Cost Fixed Cost Operating SGS 270000 125000 395000 a) Build a two-way data table that varies Var. Cost from 0.05-0.40 in increments of 0.05 on the row) and Revenue from 250,000 1,250,000 (in increments of 50,000 on the column). Add conditional formatting to the data table that indicates when a value is negative b) Add a form-control scroll bar to control Tax Rate, which should vary from 0.15 to 0.35 in 0.01 unit increments, (Remember that the values of form control are integers and between 0-30,000, so you will need a dummy value cell to adjust for the scale) Net Operating Income 9 10 11 12 13 14 15 16 17 IR 145000 Interest Expense 25000 Earnings Before Teves 120000 Taxes 408.00 034 Catex Rate Net Income 79200 unitsins 20 21 23 M N Typical Income Statement for Manufacturing Business Final Probl). The model to the right is a very simple Income/Loss Statement for a manufacturing business. There are many simplifications in this model, but an Income/Loss Statement is a very useful tool for analyzing profitability when numerous variables need to be considered. The model assumes that the variable values are known (deterministic), but this does not restrict the user from asking numerous important "What if" questions. You can determine the model's assumptions by examining the cells where calculations take place...& notice the parameters in Column N used in the calculations. Revenue 9.000.00 COGS 360000 Gross Profit 540000 04 CC00% 03 s Var.Cost Variable Cost Fixed Cost Operating SGS 270000 125000 395000 a) Build a two-way data table that varies Var. Cost from 0.05-0.40 in increments of 0.05 on the row) and Revenue from 250,000 1,250,000 (in increments of 50,000 on the column). Add conditional formatting to the data table that indicates when a value is negative b) Add a form-control scroll bar to control Tax Rate, which should vary from 0.15 to 0.35 in 0.01 unit increments, (Remember that the values of form control are integers and between 0-30,000, so you will need a dummy value cell to adjust for the scale) Net Operating Income 9 10 11 12 13 14 15 16 17 IR 145000 Interest Expense 25000 Earnings Before Teves 120000 Taxes 408.00 034 Catex Rate Net Income 79200 unitsins 20 21 23

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hotel And Restaurant Accounting

Authors: Cole Raymond

8th Edition

0866125531, 9780866125536

More Books

Students also viewed these Accounting questions

Question

13-12: How do psychologists use traits to describe personality?

Answered: 1 week ago