2 On the SalesData worksheet, in cell F4, create a formula that will perform a calculation...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2 On the SalesData worksheet, in cell F4, create a formula that will perform a calculation that multiplies the Unit Price by the sum of products sold for January, February, and March. If a product has not sold any units over the past three months, display Discontinue. If the project has sold units, display the results of the Unit Price multiplied by the sum of the products sold for January, February, and March. Copy the formula and then paste it in cells F5, F7:F9, F11:F12, F14:F15, and F17:F18. Resize the column as needed. 3 Product 4 64GB Hard Drive 5 128 GB Hard Drive 6 7 2GB Flash Drive 8 4GB Flash Drive 9 8GB Flash Drive 10 11 15" Monitor 12 18" Monitor 13 14 Keyboard 15 Ergo Keyboard 16 17 8GB RAM 18 16GB RAM 19 20 21 22 23 24 Totals by Item 25 Hard Drives 26 Flash Drives 27 Monitors 28 Keyboard 29 RAM 20 Unit Price $ 150.00 $ 249.00 B 8.00 $ $ 10.00 $ 15.00 $ 75.00 $ 100.00 is s $ 20.00 35.00 $ $ 150.00 $ 200.00 Monthly Snapshot Goal January 50 75 52 55 12 Actual Monthly Sales 12 7 20 18 5 2 13 D 3 2 February March 11 6 12 20 4 6 11 5 3 E Outcome 12 8 13 19 5 5 12 4 5 F Total H Product of the Month 75 Goal Product 2 On the SalesData worksheet, in cell F4, create a formula that will perform a calculation that multiplies the Unit Price by the sum of products sold for January, February, and March. If a product has not sold any units over the past three months, display Discontinue. If the project has sold units, display the results of the Unit Price multiplied by the sum of the products sold for January, February, and March. Copy the formula and then paste it in cells F5, F7:F9, F11:F12, F14:F15, and F17:F18. Resize the column as needed. 3 Product 4 64GB Hard Drive 5 128 GB Hard Drive 6 7 2GB Flash Drive 8 4GB Flash Drive 9 8GB Flash Drive 10 11 15" Monitor 12 18" Monitor 13 14 Keyboard 15 Ergo Keyboard 16 17 8GB RAM 18 16GB RAM 19 20 21 22 23 24 Totals by Item 25 Hard Drives 26 Flash Drives 27 Monitors 28 Keyboard 29 RAM 20 Unit Price $ 150.00 $ 249.00 B 8.00 $ $ 10.00 $ 15.00 $ 75.00 $ 100.00 is s $ 20.00 35.00 $ $ 150.00 $ 200.00 Monthly Snapshot Goal January 50 75 52 55 12 Actual Monthly Sales 12 7 20 18 5 2 13 D 3 2 February March 11 6 12 20 4 6 11 5 3 E Outcome 12 8 13 19 5 5 12 4 5 F Total H Product of the Month 75 Goal Product
Expert Answer:
Answer rating: 100% (QA)
Answer FORMULA IFSUMC4D4E4B40SUMC4D4E4B4Discontinue IFc... View the full answer
Related Book For
Supply Chain Focused Manufacturing Planning and Control
ISBN: 978-1133586715
1st edition
Authors: W. C. Benton
Posted Date:
Students also viewed these electrical engineering questions
-
20 21 22 23 24 11 14 15 7 8 9 10 13 4 6 2 3 5 ABC Co. manufactures widgets and has the following operating information for the past year: A A 12 B B Product Line Product Line Budgeted Unit Sales...
-
Flash Manufacturing manufactures 16 GB flash drives (jump drives). Price and cost data for a relevant range extending to 200,000 units per month are as follows: Sales price Per-unit (current monthly...
-
Write a formula that will convert the volume given in 1,000s into a volume given in 100s. Use the left side of the equation to indicate in which cell to store the formula. a. Intel Corp b. Yahoo! Inc...
-
Turtle Creek Partnership had the following revenues, expenses, gains, losses, and distributions Sales revenue Long-term capital gains Cost of goods sold Depreciation-MACRS $ 59,000 $ 3,300) $...
-
Nokia (www.Nokia.com), Research In Motion, and Apple are all competitors in the global marketplace. Comparative figures for these companies recent annual accounting periods follow. Required 1....
-
Dysgenic hybrids in Drosophila have elevated mutation rates as a result of P element transposition. How could you take advantage of this situation to obtain P element insertion mutations on the X...
-
Compute the expected frequencies. Exercises 1015 refer to the following data: Anthropologists can estimate the birthrate of an ancient society by studying the age distribution of skeletons found in...
-
Webster ordered a bowl of fish chowder at the Blue Ship Tea Room. She was injured by a fish bone in the chowder, and she sued the tea room for breach of the implied warranty of merchantability. The...
-
What is Sally's gross annual retirement income need (from all income sources) in TODAY's dollars at the beginning of her first year in retirement? What is Sally's net annual retirement income need...
-
Sparky's Amusement Park is an entertainment park run by recent college graduates. It caters to young people and others who are young at heart. The owners are very interested in applying what they...
-
Weather head Bakery, a bakery shop started by a Weather head alumni, went public a few years ago. The company currently pays a dividend of $0.55 annually, and pledges to grow their dividends by at a...
-
A 2 4 0 g volleyball approaches Zeenya Latture with a speed of 3 . 8 m/s. Zeenya bumps the ball, giving it a speed of 2 . 4 m/s away from her. What average force did she apply if the interaction time...
-
Discuss how terminal and instrumental values impact ethical workplace behavior
-
Discuss the role of reward systems in organizational change. Specifically, identify where reward systems work and where they undermine the organizational change process. If you have no experience in...
-
Factor by grouping. 5v +7v - 10v-14 6
-
Find (fog)(x) and (g of)(x) and the domain of each. f(x) = x + 3, g(x) = 2x-5x-3 (fog)(x) = (Simplify your answer.)
-
Write a program that prompts for two people's birthdays (month and day), along with today's month and day. The program should figure out how many days remain until each user's birthday and which...
-
Discuss the concept of the looking-glass self. how do you think others perceive you? do you think most people perceive you correctly?
-
Write a brief memo to your immediate manager discussing why the study of supply chain-focused manufacturing planning and control is important in today's competitive manufacturing environment.
-
The demand for refurbished cell phones is experiencing a decline. The company wants to monitor cell phone demand closely. The trend-adjusted exponential smoothing method is used with = 0.1 and =...
-
Consider the following demand and lead time data for Carnival Campers, Inc. DEMAND PER DAY PROBABILITY MANUFACTURING LEAD TIME (IN DAYS) PROBABILITY 1 0.4 2 0.3 2 0.6 3 0.7 a. Calculate...
-
For each of the following events concerning disclosure of events that took place after year end, discuss the manner in which it should be disclosed in the financial statements or the audit report....
-
Determining whether a subsequent event requires an adjustment to the financial statements is difficult in many circumstances. Discuss the primary difference between subsequent events that require...
-
Each of the following techniques for managing earnings was described in the chapter: - "Big Bath" charges - Write-off of acquired assets - "Cookie Jar" reserves - Abuse of materiality - Questionable...
Study smarter with the SolutionInn App