Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You work for Dreams Home Furnishing an online retailer of home furniture. Your manager wants to know the profit potential of their inventory based on

You work for Dreams Home Furnishing an online retailer of home furniture. Your manager wants to know the profit potential of their inventory based on the items in inventory listed in Table 1. The required formulas are shown in Table 2. Use the formula to create and format the worksheet. The company just received 17 additional lift chair and shipped out 50 arm chairs. a) Update the appropriate cells to reflect the change in inventory. (3 Marks) b) Total of total cost, unit price, total value, and potential profit. Use accounting number format style with fixed dollar or RM sign with two decimal places. (6 Marks) c) Average of total cost, unit price, total value and potential profit. Use currency format with floating decimal places. (5 Marks) d) Lowest and highest of unit cost, total cost, unit price, total value and potential profit. (5 Marks) e) Name your sheet tab as Profit Potential Data. Attach your answer with embed excel worksheet to Microsoft Word as an object. (1 Mark) Table 1 Dreams Home Furniture Profit Potential Data Item Units on Hand Unit cost Coffee table 100 RM39.90 Lift chair 150 RM432.50 Arm chair 300 RM120.00 Bean bag 69 RM78.90 Bar stool 85 RM81.60 Table 2 Dreams Home Furniture Inventory Profit Potential Formulas Total of Total Cost = Units on Hand X Unit Cost Total of Unit Price = Unit cost x (1 / (1-0.66) Total of Total Value = Units on Hand X Unit Price Total of Potential Profit = Total Value Total Cost Average = AVERAGE function Maximum = MAX function Minimum = MIN function.

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

Step: 3

blur-text-image

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

Financial Accounting

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

7th Edition

978-0470477151, 978-0-470-5562, 470556242, 0-470-55624-2, 9780470556245, 978-0470507018

More Books

Students also viewed these Accounting questions