Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. The company is considering increasing the selling price per bag. Build a one-way data table based on your spreadsheet model using Excel's Data

image text in transcribed

3. The company is considering increasing the selling price per bag. Build a one-way data table based on your spreadsheet model using Excel's Data Table command to show the monthly breakeven number of vegetable bags and percentage of maximum capacity with the price ranging from $1.50 to $3.00 per bag (in increments of $0.15). Put a border around the contents of the table. Format the amount inside the table as a Number with 0 decimals. Format percent values inside the table as Percentage with 0 decimals. 4. The company is considering changing its production process to add an extra cover to the bag to reduce refrigeration times that would increase the cost of a bag. Management wants to estimate how profit reacts to changes in both the variable cost and the selling price. Construct a two-way data table based on your spreadsheet model using Excel's Data Table command to show the profit associated with the selling price ranging from $1.50 to $2.75 (in increments of $0.25) as the variable cost per bag varies from $0.80 to $1.50 (in increments of $0.10 across the top of the table and assuming LQN produces at maximum capacity). Put a border around the contents of the table. Format all dollar amounts as Currency with 0 decimals. Apply conditional formatting to the cells in the table that exceed $25,000. 5. Create a line chart showing the net profit for per-bag prices of $1.75, and $2.25 using the corresponding 8 columns of your data table: Move this chart to a "New Sheet" and name it VarCost VS Profit Fixed Price. Use appropriate axis titles. Name each data series with the corresponding price in a chart legend on the right.

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

Fraud Examination

Authors: W. Steve Albrecht, Conan C. Albrecht, Chad O. Albrecht, Mark F. Zimbelman

3rd edition

324560842, 978-0324560848

More Books

Students also viewed these Accounting questions