APPLY Case Problem 3 Data File needed for this Case Problem: RoomGroom.xlsx Room and Groom Room...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
APPLY Case Problem 3 Data File needed for this Case Problem: RoomGroom.xlsx Room and Groom Room and Groom has been kenneling and grooming small, medium, and large cats and dogs in Topeka, Kansas, since June 2010. The standard kennel program includes access to the outside fenced play area, healthy meals, and private rooms. With the deluxe kennel program, the animal also has a daily playtime with a kennel employee, daily treats, and music or video playing in its room. Grooming services can occur during a kennel stay or as a standalone service. Samuel Wooten, the manager of Room and Groom, has been tracking the kennel and grooming services by month for the past year. Samuel wants you to analyze the data he has collected and create some preliminary charts. Complete the following: 1. Open the RoomGroom workbook located in the Excel6> Case3 folder included with your Data Files, and then save the workbook as RoomGroom 2017 in the location specified by your instructor. 2. In the Documentation worksheet, enter your name and the date. 3. Group the 12 monthly worksheets to ensure consistency in headings and for ease in entering formulas. Enter the heading Total in cells A11 and E4. For each month (January through December), enter formulas to calculate the total for each type of visit (the range B11:D11) and the total for each type of animal (the range E5:E11). 4. Improve the formatting of the monthly worksheets using the formatting of your choice. Be sure to include a bottom border in the ranges A4:E4 and A10:E10, Ungroup the worksheets. 5. In the Service by Month worksheet, in the range B5:B16, enter formulas with worksheet references to display the total grooming services for each month (the formulas will range from January!B11 through December!B11). Copy these formulas to the range C5:C16 (Room-Standard) and the range D5:D16 (Room-Deluxe). 6. In cells A17 and E4, enter the label Total. In the range B17:D17, enter formulas to add the total i for each type of service, and then in the range E5:E17, enter formulas to add the total services each month by animal type. 7. Add a bottom border to the ranges A4:E4 and A16:E16. Improve the formatting of the Service by Month worksheet using the formatting of your choice. 8. Create a bar chart or a column chart that compares the types of services by month (the range A4:D16). Include an appropriate chart title and a legend. Format the chart so that it is attractive and effective. Position the chart below the data. 9. In the Service by Animal worksheet, in the range 85:D10, enter formulas using 3-D cell references to sum the services for the year for each animal. For example, in cell B5, the formulas for Small Dog Groom would be =SUM(January:December!B5). 10. In cells A11 and E4, enter the label Total. In the range B11:D11, enter formulas to add the total by type of service, and then in the range E5:E11, enter formulas to add the total services and total services by animal type. 11. Add a bottom border to the ranges A4:E4 and A10:E10. Improve the formatting of the Service by Animal worksheet using the formatting of your choice. 12. Create a pie chart based on the annual total for each animal type. Include an appropriate chart title and a legend. Format the chart so that it is attractive and effective. Position the pie chart below the data in the Service by Animal worksheet. 13. Group all of the worksheets except Documentation. Prepare the workbook for printing by displaying the workbook name and the worksheet name on separate lines in the right section of the header. Display your name and the current date on separate lines in the right section of the footer. 14. Save the workbook, and then close it. APPLY Case Problem 3 Data File needed for this Case Problem: RoomGroom.xlsx Room and Groom Room and Groom has been kenneling and grooming small, medium, and large cats and dogs in Topeka, Kansas, since June 2010. The standard kennel program includes access to the outside fenced play area, healthy meals, and private rooms. With the deluxe kennel program, the animal also has a daily playtime with a kennel employee, daily treats, and music or video playing in its room. Grooming services can occur during a kennel stay or as a standalone service. Samuel Wooten, the manager of Room and Groom, has been tracking the kennel and grooming services by month for the past year. Samuel wants you to analyze the data he has collected and create some preliminary charts. Complete the following: 1. Open the RoomGroom workbook located in the Excel6> Case3 folder included with your Data Files, and then save the workbook as RoomGroom 2017 in the location specified by your instructor. 2. In the Documentation worksheet, enter your name and the date. 3. Group the 12 monthly worksheets to ensure consistency in headings and for ease in entering formulas. Enter the heading Total in cells A11 and E4. For each month (January through December), enter formulas to calculate the total for each type of visit (the range B11:D11) and the total for each type of animal (the range E5:E11). 4. Improve the formatting of the monthly worksheets using the formatting of your choice. Be sure to include a bottom border in the ranges A4:E4 and A10:E10, Ungroup the worksheets. 5. In the Service by Month worksheet, in the range B5:B16, enter formulas with worksheet references to display the total grooming services for each month (the formulas will range from January!B11 through December!B11). Copy these formulas to the range C5:C16 (Room-Standard) and the range D5:D16 (Room-Deluxe). 6. In cells A17 and E4, enter the label Total. In the range B17:D17, enter formulas to add the total i for each type of service, and then in the range E5:E17, enter formulas to add the total services each month by animal type. 7. Add a bottom border to the ranges A4:E4 and A16:E16. Improve the formatting of the Service by Month worksheet using the formatting of your choice. 8. Create a bar chart or a column chart that compares the types of services by month (the range A4:D16). Include an appropriate chart title and a legend. Format the chart so that it is attractive and effective. Position the chart below the data. 9. In the Service by Animal worksheet, in the range 85:D10, enter formulas using 3-D cell references to sum the services for the year for each animal. For example, in cell B5, the formulas for Small Dog Groom would be =SUM(January:December!B5). 10. In cells A11 and E4, enter the label Total. In the range B11:D11, enter formulas to add the total by type of service, and then in the range E5:E11, enter formulas to add the total services and total services by animal type. 11. Add a bottom border to the ranges A4:E4 and A10:E10. Improve the formatting of the Service by Animal worksheet using the formatting of your choice. 12. Create a pie chart based on the annual total for each animal type. Include an appropriate chart title and a legend. Format the chart so that it is attractive and effective. Position the pie chart below the data in the Service by Animal worksheet. 13. Group all of the worksheets except Documentation. Prepare the workbook for printing by displaying the workbook name and the worksheet name on separate lines in the right section of the header. Display your name and the current date on separate lines in the right section of the footer. 14. Save the workbook, and then close it.
Expert Answer:
Answer rating: 100% (QA)
It seems like you need assistance with a specific case problem involving data analysis and chart creation in Excel Since I cant directly interact with ... View the full answer
Related Book For
South-Western Federal Taxation 2018 Comprehensive
ISBN: 9781337386005
41st Edition
Authors: David M. Maloney, William H. Hoffman, Jr., William A. Raabe, James C. Young
Posted Date:
Students also viewed these programming questions
-
Becoming less between individual companies, and more between the s Richard Wilding, a British academic and business professional specia pply chain management. What do you think about this statement?...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
An investor has $60,000 to invest in a $280,000 property. He can obtain either a $220,000 loan at 9.5 percent for 20 years or a $180,000 loan at 9 percent for 20 years and a second mortgage for...
-
What is the state postulate?
-
Sketch vo for the network of Fig. 2.170 and determine the dc voltage available. Ideal diodes 170 V 2.2 k -Vo + 2.2 k -170 V 2.2 k2
-
Water flows uniformly at a depth of \(1 \mathrm{~m}\) in a channel that is \(5 \mathrm{~m}\) wide as shown in Fig. P10.63. Further downstream, the channel cross section changes to that of a square of...
-
Accounts Payable Confirmations. Partners Clark and Kent, both CPAs, are preparing their audit plan for the audit of accounts payable on Marlboro Corporations annual audit. Saturday afternoon they...
-
A cooperative group housing society wants to establish a sinking fund to accumulate Rs.25,00,000 in 3 years to repair the society fencing. The fund earns 12% interest compounded monthly. If there are...
-
There is a parcel of land next to the Playful Paws, Inc. building. Ellen, the owner of this property, approached John to discuss the idea of selling it to him. John is interested. Ellen knows that...
-
Use Euler's method with step sizes h = 0.1 and h 0.05 to find approximate values of the solution of the initial value problem y = +1, y (1) = 1 at = 0, 0.1, and 1.0 3 !! %3D Compare these...
-
Solve: vr +4-r+2=0.
-
Metis Inc. provided the following information for its manufacturing division: Revenues $664,000 Operating expenses 416,000 Service department charges 91,800 Invested assets 576,000 Assume that Metis...
-
Dynamic job search model with discrete wage: A model economy runs for an infinite number of periods. The total population is 1. At the beginning of period 1, everyone is unemployed. A job-finding...
-
binary vending machine program in C++. This machine is called "binary" since it sells only two items of user's choice. The names, prices, and initial amount of these items will be defined by the...
-
What is the cost of a sink that is marked up $171 if the markup rate is 60% based on cost? Find the selling price. The cost is $ (Simplify your answer. Type an integer or decimal rounded to the...
-
Statement 1: In a colonial economy, the occupational structure is characterized by a large number of people working in agriculture and a small number working in industry. Statement 2: In a colonial...
-
You continue to work in the corporate office for a nationwide convenience store franchise that operates nearly 10,000 stores. The per- store daily customer count (i.e., the mean number of customers...
-
The Wren Construction Company reports its income by the completed con-tract method. At the end of 2017, the company completed a contract to con-struct a building at a total cost of $800,000. The...
-
Aman, a sole proprietor and rental property owner, had the following expenses in 2017: Specify whether each expense would be deducted for adjusted gross income (AGI) or from AGI on Amans 2017 tax...
-
Assume the same facts as in Problem 31, except that A uses a single-factor apportionment formula that consists solely of sales and B uses a three-factor apportionment formula that equally weights...
-
Briefly explain the difference between accounting, finance, and engineering economics. Try to put the concepts in your own (or your team's) words and compare the concepts where appropriate.
-
What are the two key financial objectives in the management of a company? How can a focus on these objectives create ethical dilemmas?
-
Among your colleagues in class, identify a term or phrase italicized in this chapter that you think is the most significant from your reading. Absent team consensus, then just provide your...
Study smarter with the SolutionInn App