Using the worksheet pictured above, answer the following questions:a.Describe the steps you would follow to create the Profit calculation portion of the worksheet. Within the Profit calculation portion of the worksheet pictured, which cells would contain formulas? Specify each cell that would contain a formula and what each of those formulas would be.b.Describe the steps you would follow to create the Data table portion of the worksheet pictured.c.What is the current break even volume of sales if the selling price remains at $50? How do you know?d.If the company raises the selling price to $60 and sells 600 units, what would be the operating income?e.If the company's suppliers increase the cost of direct materials, would you expect the table to contain the same, fewer, or more shaded cells?f.If the company can negotiate lower plant property taxes with the county, would you expect the table to contain the same, fewer, or more shaded cells?g.If the company increased its target profit goal to $15,000 per month, would you expect the table to contain the same, fewer, or more shaded cells? 12WN34567891011ԼՈABA1 Profit calculation2 Sales price per unit3 Less: Variable cost per unit4 Contribution margin per unit5 Ã- Volume6 Total contribution margin7 Less: Fixed expenses8 Operating income910 Monthly target profit (minimum)Bс$50$20$30700$21,000$12,000$9,000$9,999 123456789101112131415AA1 What if analysis$9,00023456 PART78910111213B14900850800750700650600550500450400350Bс$45$10,500$9,250$8,000$6,750$5,500$4,250$3,000$1,750$500($750)($2,000)($3,250)CD$50$15,000$13,500$12,000$10,500$9,000$7,500$6,000$4,500$3,000$1,500$0($1,500)DE$55$19,500$17,750$16,000$14,250$12,500$10,750$9,000$7,250$5,500$3,750$2,000$250EF$60$24,000$22,000$20,000$18,000$16,000$14,000$12,000$10,000$8,000$6,000$4,000$2,000F$65$28,500$26,250$24,000$21,750$19,500$17,250$15,000$12,750$10,500$8,250$6,000$3,750GH$70$33,000$30,500$28,000$25,500$23,000$20,500$18,000$15,500$13,000$10,500$8,000$5,500

Using the worksheet pictured above, answer the following questions: a. Describe the steps you…

Answered: Using the worksheet pictured above,…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Using the worksheet pictured above, answer the following questions:

Describe the steps you would follow to create the Profit calculation portion of the worksheet. Within the Profit calculation portion of the worksheet pictured, which cells would contain formulas? Specify each cell that would contain a formula and what each of those formulas would be.

Describe the steps you would follow to create the Data table portion of the worksheet pictured.

What is the current break even volume of sales if the selling price remains at $50? How do you know?

If the company raises the selling price to $60 and sells 600 units, what would be the operating income?

If the company's suppliers increase the cost of direct materials, would you expect the table to contain the same, fewer, or more shaded cells?

If the company can negotiate lower plant property taxes with the county, would you expect the table to contain the same, fewer, or more shaded cells?

If the company increased its target profit goal to $15,000 per month, would you expect the table to contain the same, fewer, or more shaded cells?

1
2
WN
3
4
5
6
7
8
9
10
11
ԼՈ
A
B
A
1 Profit calculation
2 Sales price per unit
3 Less: Variable cost per unit
4 Contribution margin per unit
5 Ã- Volume
6 Total contribution margin
7 Less: Fixed expenses
8 Operating income
9
10 Monthly target profit (minimum)
B
с
$50
$20
$30
700
$21,000
$12,000
$9,000
$9,999

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
A
A
1 What if analysis
$9,000
23456 PART
7
8
9
10
11
12
13
B
14
900
850
800
750
700
650
600
550
500
450
400
350
B
с
$45
$10,500
$9,250
$8,000
$6,750
$5,500
$4,250
$3,000
$1,750
$500
($750)
($2,000)
($3,250)
C
D
$50
$15,000
$13,500
$12,000
$10,500
$9,000
$7,500
$6,000
$4,500
$3,000
$1,500
$0
($1,500)
D
E
$55
$19,500
$17,750
$16,000
$14,250
$12,500
$10,750
$9,000
$7,250
$5,500
$3,750
$2,000
$250
E
F
$60
$24,000
$22,000
$20,000
$18,000
$16,000
$14,000
$12,000
$10,000
$8,000
$6,000
$4,000
$2,000
F
$65
$28,500
$26,250
$24,000
$21,750
$19,500
$17,250
$15,000
$12,750
$10,500
$8,250
$6,000
$3,750
G
H
$70
$33,000
$30,500
$28,000
$25,500
$23,000
$20,500
$18,000
$15,500
$13,000
$10,500
$8,000
$5,500

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions