Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Independent Challenge 3 Prestige Press is a Boston-based publisher that manufactures children's books. As the finance manager for the co one of your responsibilities is

image text in transcribed
image text in transcribed
image text in transcribed
Independent Challenge 3 Prestige Press is a Boston-based publisher that manufactures children's books. As the finance manager for the co one of your responsibilities is to analyze the monthly reports from the five district sales offices. Your boss, Joanne Bennington, has just asked you to prepare a quarterly sales report for an upcoming meeting Because several top execu tives will be attending this meeting, Joanne reminds you that the report must look professional. In particular, she asks you to emphasize the company's surge in profits during the last month and to highlight the fact that the Northeastern district continues to outpace the other districts. mpany Plan a worksheet that shows the company's sales during the first quarter. Assume that all books are the same price. Make sure you include the following: The number of books sold (units sold) and the associated revenues (total sales) for each of the five district a. sales offices. The five sales districts are Northeastern, Midwestern, Southeastern, Southern, and Western Calculations that show month-by-month totals for January, February, and March, and a 3-month cumulative total. Calculations that show each district's share of sales (percent of Total Sales). Labels that reflect the month-by-month data as well as the cumulative data. Formatting enhancements such as data bars that emphasize the recent month's sales surge and the Northeastern district's sales leadership. * . b. Ask yourself the following questions about the organization and formatting of the worksheet: What worksheet title and labels do you need, and where should they appear? How can you calculate the totals? What formulas can you copy to save time and keystrokes? Do any of these formulas need to use an absolute reference? How do you show dollar amounts? What information shoal be shown in bold? Do you need to use more than one font Should you use more than one point size I then save a new, blank workbook as Lt. .ennge Press to the location where you store your Data Files. cacing a Worksheet

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

Pro PowerShell For Database Developers

Authors: Bryan P Cafferky

1st Edition

1484205413, 9781484205419

More Books

Students also viewed these Databases questions

Question

What does OSHA do?

Answered: 1 week ago