Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compare the results from each of the three months to the original data and to each other Do not just state the numbers - indicate

image text in transcribed

image text in transcribed

  • Compare the results from each of the three months to the original data and to each other
  • Do not just state the numbers - indicate what the numbers are telling us
  • Mention what will help make business decisions (be specific - make recommendations to a client)
  • The explanations should be brief like bullet points (not lengthy sentences, not a paragraph)
  • The explanations should include graphics (up arrow for increase, down arrow for decrease, etc.)
. . . . Start with the completed Actual sheet created in the Excel file from the LabFile 9-7 assignment (not the Breakeven sheet) Make the changes below to the Actual sheet in the sequence listed (do not go back to the original Actual sheet) Create a series of slides using Google Slides or PowerPoint with a title on each slide First slide - include your name as it appears in Canvas, the course and section number (ACG ####-###), and the term and year Second slide - insert all the data from the Actual sheet created in LabFile 9-7 before any Goal Seek tasks were done (as large as you can make it on the slide) Third slide - insert all the data from the revised Actual sheet after performing a breakeven analysis using Goal Seek for March only by changing the Unit of Sales Fourth slide - insert all the data from the revised Actual sheet after performing a breakeven analysis using Goal Seek for April only by changing the Price Fifth slide - insert all the data from the revised Actual sheet after performing a breakeven analysis using Goal Seek for May only by changing the Unit Cost Sixth slide - analyze the results from all the breakeven tasks Compare the results from each of the three months to the original data and to each other . Do not just state the numbers - indicate what the numbers are telling us Mention what will help make business decisions (be specific - make recommendations to a client) . The explanations should be brief like bullet points (not lengthy sentences, not a paragraph) The explanations should include graphics (up arrow for increase, down arrow for decrease, etc.) D E F March April May 7.00 7.13 7.00 312.50 300.00 300.00 3.80 3.80 3.67 1000.00 1000.00 1000.00 1187.50 1140.00 1100.00 2187.50 2140.00 2140.00 2100.00 2187.50 2140.00 2100.00 0.00 0.00 0.00 . . . . Start with the completed Actual sheet created in the Excel file from the LabFile 9-7 assignment (not the Breakeven sheet) Make the changes below to the Actual sheet in the sequence listed (do not go back to the original Actual sheet) Create a series of slides using Google Slides or PowerPoint with a title on each slide First slide - include your name as it appears in Canvas, the course and section number (ACG ####-###), and the term and year Second slide - insert all the data from the Actual sheet created in LabFile 9-7 before any Goal Seek tasks were done (as large as you can make it on the slide) Third slide - insert all the data from the revised Actual sheet after performing a breakeven analysis using Goal Seek for March only by changing the Unit of Sales Fourth slide - insert all the data from the revised Actual sheet after performing a breakeven analysis using Goal Seek for April only by changing the Price Fifth slide - insert all the data from the revised Actual sheet after performing a breakeven analysis using Goal Seek for May only by changing the Unit Cost Sixth slide - analyze the results from all the breakeven tasks Compare the results from each of the three months to the original data and to each other . Do not just state the numbers - indicate what the numbers are telling us Mention what will help make business decisions (be specific - make recommendations to a client) . The explanations should be brief like bullet points (not lengthy sentences, not a paragraph) The explanations should include graphics (up arrow for increase, down arrow for decrease, etc.) D E F March April May 7.00 7.13 7.00 312.50 300.00 300.00 3.80 3.80 3.67 1000.00 1000.00 1000.00 1187.50 1140.00 1100.00 2187.50 2140.00 2140.00 2100.00 2187.50 2140.00 2100.00 0.00 0.00 0.00

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_2

Step: 3

blur-text-image_3

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

Key Financial Market Concepts

Authors: Bob Steiner

2nd Edition

0273750127, 978-0273750123

More Books

Students also viewed these Finance questions