Question: Complete all items for Problem 14-47 in the textbook.
All parts of the problems should be prepared in an Excel workbook. Provide supporting responses either as part of the Excel document or as a separate Word document (400-750 words), being sure to properly label each response. Please note, you must show your work in Excel, which includes providing the formulas in the cells, not just the summary value. You may not earn full points if you do not show your work in detail.
At least two external sources should be cited.
1. Should Tipton close its wallpaper operation? Show computations to support your answer.
2. Assume that Tipton's wallpaper inventory at the time of the closure decision amounted to $23,700. How would you have treated this additional information in making the decision?
3. What advantages might Internet- and magazine-based firms have over Tipton that would allow these organizations to offer deeply discounted prices-prices far below what Tipton can offer?
4. Build a spreadsheet: Construct an Excel spreadsheet to solve requirement (1) above. Show how the solution will change if the following information changes: sales were $400,000, $450,000, and $130,000, for paint and supplies, carpeting, and wallpaper, respectively.
Information related to above question is enclosed below:
Attachment:- Problem14-47.rar