Question: What formula do I put in excel to find projected 20x6 sales?? I tried =FUNCTION(A2,B2:F13,A13) with no luck. A B C D E F G

What formula do I put in excel to find projected 20x6 sales?? I tried =FUNCTION(A2,B2:F13,A13) with no luck.

What formula do I put in excel to find projected

A B C D E F G . 1 J K L M 20x2 35000 1 Month(Jan-Dec) 20x1 2 Jan 3 Feb 20x3 8000 20x4 12000 20x5 15000 20x6 (y=mx+b) 15000 12000 Sales 30000 8000 14000 8000 12000 22000 25000 4 Mar 10000 18000 15000 16000 18000 14000 18000 13000 14000 14000 18000 15000 18000 18000 16000 20000 15000 5 Apr 5 May 7 Jun 3 Jul 3 Aug 10000 18000 18000 20000 18000 17000 10000 16000 14000 20000 28000 5000 18000 20000 28000 22000 27000 20000 25000 28000 22000 26000 LO Sep 28000 20000 0 1 Oct 27000 28000 30000 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec L2 Nov 24000 26000 20000 22000 18000 10000 18000 18000 209000 22000 28000 20x1 20x2 20x3 20x4 3 Dec -4 Total 5 20x5 195000 216000 230000 No 265000 a=demand 20x1 b=yearly demand X=

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Tom Randall, President and founder of Randalls Rewriteable CDs, has a problem. The 2021 fiscal year begins on April 1st and Tom has to have the Quarter 1 2021 master budget ready to be presented to...

Use EXCEL only please, also make a data analyst excel file thanks! EntertainmentTech Research Analyst - 50% You have been hired to work as a research analyst at Entertainment Tech. EntertainmentTech...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

Averell Cabinetry Case Overview This case is presented as close as possible to the way you may encounter it in working life. Your role is that of a newly hired HR manager. You will learn about the...

Managerial Accounting Case Bon-Ton: Caught In The Rain of US Retail Bankruptcies ** ONLY ATTEMPT THIS** IF YOU WILL READ CAREFULLY AND CAN EXPLAIN USING: (1) Accounting, Economics, and Financial...

now//You are asked to price some options on KYC stock. KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent,...

KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...

There are three parts to this case. A-1; A-2; and A-3. I need help with A-2 the most (i.e., Ratio Analysis). For all parts of this question use: Excel spreadsheet, describe and explain everything in...

Accounting Homework Case Bon-Ton: Caught In The Rain of US Retail Bankruptcies ONLY ATTEMPT THIS QUESTION IF YOU ARE CONFIDENT! A step-by-step breakdown and analysis is preferred using Accounting...

A-1 Help me to describe the main issues facing Bon-Ton. Help me to analyze the company's strengths, weaknesses, opportunities, and threats. A-2 Please explain how can I evaluate and analyze the...

Under what condition(s) does the policy ineffectiveness proposition (PIP) hold?

For your final paper, you will be completing a comprehensive analysis of a town, city, county or state. Using the information learned throughout the course, with an emphasis on the information in...

A taxpayer receives a deduction for services rendered to a charitable organization.True or False

What is an example of constructive feedback? provide reference