Calculate the gross profit which is equal to the gross sales

Assignment Help Financial Accounting

Reference no: EM13955803

Case Problem

Data File needed for this Case Problem: Salon.xlsx

Open the Salon workbook located in the Excel2? Case1 folder included with your Data Files, and then save the workbook as Salon Income Statement in the location specified by your instructor.

In the Documentation sheet, enter your name in cell B3 and the date in cell B4.

Apply the following formatting to the Documentation sheet:

1. Format cell A1 using the Title cell style.

2. Format the range A3:A5 using the Accent6 cell style.

3. In cell B4, format the date value using the long date format, and left-align the cell contents.

4. In cell B5, format the text string "Special Highlights Hair Salon" in italic.

In the Income Statement worksheet, format cell A1 using the Title cell style.

Calculate the following items in the Income Statement worksheet:

a) In cell C7, calculate the Gross Profit, which is equal to the Gross Sales minus the Cost of Sales.

b) In cell C21, calculate the Total Operating Expenses, which is equal to the sum of the operating expenses.

c) In cell C22, calculate the Total Operating Profit/Loss, which is equal to the Gross Profit minus the Total Operating Expenses.

d) In cell C23, calculate the projected Income Taxes, which is equal to 35 percent of the Total Operating Profit/Loss.

e) In cell C24, calculate the Net Profit/Loss, which is equal to the Total Operating Profit/Loss minus the projected Income Taxes.
Set the following formats to the Income Statement worksheet:

a) Format cells A3 and A26 using the Heading 2 cell style.

b) Format cells A4 and A9 and the range A27:A38 in bold.

c) Format cells B5, C7, B10, C21, and C24 using the Accounting format with no decimal places.

d) Format cells B6, B11:B19, C22, and C23 using the Comma style with no decimal places.

e) Indent the text in the ranges A5:A6 and A10:A19 two spaces. Indent the text in cell A7 and the range A21:A24 four spaces.

f) Add a bottom border to cells B6, C7, C21, C22, and C23. Add a double bottom border to cell C24.

Merge cells A26:E26 and then left-align the merged cell's contents.

Merge the contents of the range B27:E27. Left-align the merged cell's contents and wrap the text within the cell. Increase the height of row 27 to display the entire contents of the cell.

Top-align and left-align the range A27:B38.

Copy the format from the range A27:B27 to the range A28:B38. Merge columns B through E in each row, left-align the text, and resize the row heights to display the complete contents of the cells.

Italicize the text string "National Salon News" in cells B27 and B28.

Set the following printing formats to the Income Statement worksheet:

a) Insert a manual page break directly above row 26 so that the Income Statement prints on two pages.

b) Set rows 1 and 2 as a print title to print on both pages.

c) Change the page margins to 1 inch on every side.

d) On the first page of the printout, print Prepared by your name in the left section of the header, where your name is your name. Print the current date in the right section of the header. Do not display header text on any other page.

e) For every page, add a footer that prints the workbook filename in the left section, Page page in the center section, and the worksheet name in the right section.

If you are instructed to print, print the entire contents of the workbook in portrait orientation.

Save and close the workbook.

Attachment:- Salon.xlsx

Reference no: EM13955803

Questions Cloud

Current method of funding for highways : Funding Highways. In 200 - 250 words assess the current method of funding for highways. In addition, include your opinion of fairness as it relates to the trucking industry.

How fast must the centerfielder''s throw leave his hand : The fielder then attempts to throw the ball to the base ahead of the runner. If a base-runner can run from 3rd base to home plate in 4.0 sec, how fast must the centerfielder's throw leave his hand if he makes the catch then immediately throws the ..

Construct a decision tree for the problem. : If the decision maker knows nothing about the probabilities of the three states of nature, what is the recommended decision using the optimistic, conservative and minimax regret approaches?

Social responsibility pricing : Social Responsibility Pricing. The text discusses "Social responsibility pricing". Some argue that a business cannot sustain itself if it practices social responsible pricing.

Calculate the gross profit which is equal to the gross sales : calculate the Gross Profit, which is equal to the Gross Sales minus the Cost of Sales. Calculate the Total Operating Expenses, which is equal to the sum of the operating expenses. Calculate the Total Operating Profit/Loss.

Mitigating risk in transportation costs : Discuss how accounting, economic, and social costs can be used in transportation to mitigate risks associated with these costs - Analyze how the company's focus can impact these costs and impact risks.

What would the temperature of the calorimeter mixture : What affect would there be on the calculated value of L if we waited a significantly long amount of time after the ice melted to read the final mixture temperature rather than promptly reading the thermometer? Assume the environment is at a lower ..

Explain the steps in the strategic training : Identify and summarize five models used to organize training departments. If you were the Vice President of Human Resource Training, which model would you choose to organize your department? Explain why you would choose this model. One page /275 w..

Calculate latent heat of fusion from heat balance equation : Calculate the latent heat of fusion from the heat balance equation using the following experimental set of data. Compare this value with the value given in the textbook.

User Account

All Pages