Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You work for HumiCorp, an online retailer of home humidifi ers. Your manager wants to know the profit potential of their inventory based on the

You work for HumiCorp, an online retailer of home humidifi ers. Your manager wants to know the profit potential of their inventory based on the items in inventory listed in Table 2?12. Table 2?12 contains the format of the desired report. The required formulas are shown in Table 2_13. Use the concepts and techniques developed in this chapter to create and format the worksheet. The company just received 67 additional desk-sized humidifi ers and shipped out 48 room-sized

humidifi ers. update the appropriate cells to reflect the change in inventory.

Table HumICorp Inventory Profit Potential Data and Worksheet Layout.

Table 2 HumiCorp Inventory Profit Potential Formulas:

Formula A = Units on Hana x unit Cost

Formula B = unit Cost x (1 / 1-0.66))

Formal C = Units on Hand x unit Price

Formula D = Total Value -Total Cost

Formula E = AVERAGE function

Formula F = MIN function

Formula G = MAX function

Tem Desk Filtered home-sized 42 Filtered room-sized 118 103 Home-sized Room-sized 97 53.69 Units on Hand Unit Cost Total Cost 187 27.58 Total Average Lowest Highest Formula E Formula F Formula G 324.14 86.55 253.91 Formula A;Formula B Unit Price Formula C Formula D Total Value Potential Profit

Step by Step Solution

3.32 Rating (158 Votes )

There are 3 Steps involved in it

Step: 1

Analyzing Profit Potential You want to know the profit potential of inventories based on item in inventory Steps needed for preparing worksheet of item are as follow 1 Open Microsoft Excel 2010 Micros... 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

Document Format ( 2 attachments)

PDF file Icon
608fe68231699_21355.pdf

180 KBs PDF File

Word file Icon
608fe68231699_21355.docx

120 KBs Word File

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

Matching Supply with Demand An Introduction to Operations Management

Authors: Gerard Cachon, Christian Terwiesch

3rd edition

73525200, 978-0073525204

More Books

Students also viewed these Accounting questions

Question

What's the business case for work-life programs? AppendixLO1

Answered: 1 week ago

Question

Briefly define Galens constitutional types.

Answered: 1 week ago

Question

What does stickiest refer to in regard to social media

Answered: 1 week ago