Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

. . . . Start with the completed Actual sheet created in the Excel file from the LabFile 9-7 assignment (not the Breakeven sheet) Make

image text in transcribedimage text in transcribed

. . . . 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

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

Cost Accounting With Integrated Data Analytics

Authors: Karen Congo Farmer, Amy Fredin

1st Edition

1119731860, 9781119731863

More Books

Students also viewed these Accounting questions

Question

How prepared was the organization for the new business strategy?

Answered: 1 week ago