Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started