1 Input Data Model 2 Unit Cost 3 Unit Price 4 Demand 5 Annual Fixed Cost $10 $20

Question

1 Input Data Model 2 Unit Cost 3 Unit Price 4 Demand 5 Annual Fixed Cost $10 $20 7 Financial Spreadsheet 8 Variable Cost 9 Fixed Cost 10 Expenses 11 Revenue 12 Profit 13 $5,000 $10,000 $15,000 $10,000 55,000 In the picture shown here, you are looking at a simple data model, and a sma financial spreadsheet, which uses data from the Input Data model, to compute Profit in B12 16 Unit Price 17 18 19 $24.00 21 $30.00 23 24 25 26 27 28 You want to use Excel's one-way Data Model to compute the profit, for the different unt Prices shown 20 to $40. You know that you have to put the formula of Profit somewhere! To compute the profit in 817 to B27, where do you place the formula of Profit?

Explanation / Answer

here we are given unit cost of one item =$10

no of item =n=500

so variable cost is =500*10=$5000

fixed cost is :$10000

so total cost is or we say cp=$5000+$10000=$15000

total revenue or sp=price per unit sell* no of item

in b12 : price per unit is =$20

so total revenue =20*500=$10000

total profit is :total revenue-total cost=10000-15000=-$5000

so minus means we have loss

revenue(total unit*unit price)

in $

total cost(fixed +variable)

in $

profit(revenue-tota cost)

in $

profiit or loss

(-loss)

please comment if any issue ..

unit price total unit

revenue(total unit*unit price)

in $

total cost(fixed +variable)

in $

profit(revenue-tota cost)

in $

profiit or loss

(-loss)

$20 500 10000 15000 -5000 loss $22 500 11000 15000 -4000 loss $24 500 12000 15000 -3000 loss $26 500 13000 15000 -2000 loss $28 500 14000 15000 -1000 loss $30 500 15000 15000 0 nothing $32 500 16000 15000 1000 profit $34 500 17000 15000 2000 profit $36 500 18000 15000 3000 profit $38 500 19000 15000 4000 profit $40 500 20000 15000 5000 profit

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.