Time Period 1 2 3 4 5 6 7 8 9 10 11 12 BU 3310...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Time Period 1 2 3 4 5 6 7 8 9 10 11 12 BU 3310 Business Finance-Marc Payeur Actual Sales S 2,425,000 2,458,000 2.505,000 2,640,000 2,550,000 2,580,000 2,612,000 2,628,000 2,670,000 2,705,000 2,730,000 2,735,000 1. Using Excel-recreate this spreadsheet and then do the following: a. Create two new columns and calculate and compare a 3 month moving average and a weighted average forecast for months 4 through 12, using the weights 3, 5, and 8. Create two new columns showing the AIA-FI of each method b. c. Determine the MAD for each forecast and note which is more accurate. d. Using the Linear Regression - forecast months 13-24. This is the forecast for the business WITHOUT the new product. e. In a column next to your 13-24 forecast, create a new forecast for 13-24 by adding Marty's desired increase in sales from the sale of new hoverboards in order to earn the extra $30,000 profit (Sales dollars from BE part # 5). This is the forecast for the business WITH the new product. PART III - Effective Rate of Interest (15 points) 1. The Raw Materials Marty McFly purchases cost $50 each. Using the units you determined in your Break Even Analysis for the $30,000 profit (from BE part # 5). Calculate the total Marty McFly needs to spend each month in order to purchase those raw materials. 2. Marty McFly purchases these materials from Holomax Inc. under sales conditions of 3/10 N/30. a. What would the Effective Rate of Interest be if payment were made on day 10? b. Day 11? c. And on day 30? Time Period 1 2 3 4 5 6 7 8 9 10 11 12 BU 3310 Business Finance-Marc Payeur Actual Sales S 2,425,000 2,458,000 2.505,000 2,640,000 2,550,000 2,580,000 2,612,000 2,628,000 2,670,000 2,705,000 2,730,000 2,735,000 1. Using Excel-recreate this spreadsheet and then do the following: a. Create two new columns and calculate and compare a 3 month moving average and a weighted average forecast for months 4 through 12, using the weights 3, 5, and 8. Create two new columns showing the AIA-FI of each method b. c. Determine the MAD for each forecast and note which is more accurate. d. Using the Linear Regression - forecast months 13-24. This is the forecast for the business WITHOUT the new product. e. In a column next to your 13-24 forecast, create a new forecast for 13-24 by adding Marty's desired increase in sales from the sale of new hoverboards in order to earn the extra $30,000 profit (Sales dollars from BE part # 5). This is the forecast for the business WITH the new product. PART III - Effective Rate of Interest (15 points) 1. The Raw Materials Marty McFly purchases cost $50 each. Using the units you determined in your Break Even Analysis for the $30,000 profit (from BE part # 5). Calculate the total Marty McFly needs to spend each month in order to purchase those raw materials. 2. Marty McFly purchases these materials from Holomax Inc. under sales conditions of 3/10 N/30. a. What would the Effective Rate of Interest be if payment were made on day 10? b. Day 11? c. And on day 30?
Expert Answer:
Answer rating: 100% (QA)
I understand now Heres a stepbystep guide on how to complete the tasks you provided Recreate the Spreadsheet Create a new Excel workbook and enter the given data into columns A and B Time Period Actua... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
1. A nominal annual interest rate is 8.50%, compounded monthly. What are equivalent effective monthly and annual interest rates? 2. If the effective monthly interest rate is 1.50% per month, what is...
-
Period Average annual rate of inflation 3 months 5 2 years 6 5 years 8 10 years 85 20 years 9 a If the real rate of interest is currently 25 find the nominal rate of interest on each of the following...
-
a Perform a 2period, 3period and 4period moving average b Forecast sales for periods 85, 86, 87, and 88 c Using the data from periods 1 to 84, compute for the MAD, MAPE, MSE, RMSE, Based on your...
-
The comparative balance sheet of Merrick Equipment Co. for December 31, 20Y9 and 20Y8, is as follows: Dec. 31, 20Y9 Dec. 31, 20Y8 Assets Cash $70,720 $47,940 Accounts receivable (net) 207,230 188,190...
-
Using information on the Web, find (or try to estimate) your computers energy consumption. What are ways to decrease your computers energy consumption?
-
A drug is ordered with a loading doseof 25 mcg/kg over 10 minutes in 50 mL of D5W. This is followed by a continuous infusion of 0.75 mcg/kg/min in1000 mL of D5W/LR. The patient weighs 176 lbs. The...
-
For an endothermic reaction, \(H\) is (a) - ve (b) 0 (c) + ve (d) Unpredictable.
-
Gabi Gram started The Gram Co., a new business that began operations on May 1. The Gram Co. completed the following transactions during its first month of operations. May 1 G. Gram invested $40,000...
-
The operating revenues of the three largest business segments for Time Warner, Inc., for a recent year follow. Each segment includes a number of businesses, examples of which are indicated in...
-
AG Mechanical is planning to acquire Foster Metal works. Foster's cost of equity is 12%; it is financed 80% by common equity and the remainder by debt at 7%. Foster's tax rate is 30%. Below is a...
-
What earns more, an APR of 3.5% compounded monthly for 1 year, or an APR of 3.25% compounded daily for 1 year? Assume the same principal for both.
-
When should you use visuals?
-
What are some specific ways to choose effective images?
-
What information does a Gantt chart convey?
-
Why would you use a numerical table instead of a graph?
-
What are some guidelines for integrating visuals into your text?
-
Assume that there was a sign on the ladder that said, " Do Not Stand on Top Step" and Jimstood on the top step. Also assume that by not heeding the warning Jimfailed to act as a reasonable person...
-
Identify the tax issues or problems suggested by the following situations. State each issue as a question. Jennifer did not file a tax return for 2007 because she honestly believed that no tax was...
-
-3+ (-2) Find the sum by hand.
-
= [x21P(Xi)] 2; x1 = 0, x2 = 1, x3 = 2, x4 = 3, P(x1) = 0.4, P(x2) = 0.1, P (x3) = 0.2, P (x4) = 0.3, = 1.4 (standard deviation of a discrete random variable)
-
Let n be the number of hours a student studies for a quiz, and let s be the students score (in points) on the quiz. Identify the explanatory and the response variables. Which variable should be...
-
Determine the static deflection of the spring in the system of Figure P2.21. E m k FIGURE P 2.21 E, I
-
Determine the static deflections in each of the springs in the system of Figure P2.22. 40 cm 20 cm 1 x 105 N/m 2 x 105 N/m FIGURE P 2.22 4 kg
-
A \(30 \mathrm{~kg}\) compressor sits on four springs, each of stiffness \(1 \times 10^{4} \mathrm{~N} / \mathrm{m}\). What is the static deflection of each spring.
Study smarter with the SolutionInn App