Please use Excel to solve Problem 3-16 of the textbook. Please use the general ABC template as illustrated on page 139 of your textbook in your solution.

The paper is worth a possible 25 points toward your grade.

All work must be your own and please use formulae whenever you can. A base data sheet will be provided through FOLIO in the Homework folder. Please prepare and submit a report with the similar format as depicted on page 139. NOTE!!! The report should be on a SEPARATE TAB IN THE EXCEL WORKSHEET so that all cells on the separate tab (in the report) should be nothing but ALL formulae (except for the textual material). Thus, all additions, subtractions, etc, as well as the inter-worksheet references should all be formulae.

REQUIRED.

Please turn to pages 152-153 of the text (CASE problem for Chapter 3). Coffee Bean Inc.

Please open up ExcelHW1 excel spreadsheet in Folio Assignment folder (writing and excel assignments folder.

Please prepare an excel report with the similar format as depicted on page 139 of your text. NOTE!!! The report should be on a SEPARATE TAB IN THE EXCEL WORKSHEET so that all cells on the separate tab (in the report) should be nothing but ALL formulae (except for the textual material).

(textbook Introduction to Managerial Accounting Brewer, 6th ed)