18. New car sales for a dealer in Cook County, Illinois, for the past year are shown in the following table, along with monthly indexes (seasonal relatives), which are supplied to the dealer by the regional distributor. Month Units Sold Index Jan. 640 0.80 Feb. 648 0.80 Mar. 630 0.70 Apr. 761 0.94 May. 735 0.89 Jun. 850 1.00 Jul. 765 0.90 Aug. 805 1.15 Sept. 840 1.20 Oct. 828 1.20 Nov. 840 1.25 Dec. 800 1.25 a. Plot the data. Does there seem to be a trend? b. Deseasonalize car sales. c. Plot the deseasonalized data on the same graph as the original data. Comment on the two graphs. d. Assuming no proactive approach on the part of management, discuss (no calculations neces- sary) how would forecast sales for the first three months of the next year. you e. What action might management consider based on your findings in part b?
Q: 12.14. The Great Northwest Outdoor Company is a catalog sales operation that specializes in outdoor…
A: given,
Q: Below are the production demands for the first four months of the year. What is the 4 month moving…
A: The process of forecasting entails creating predictions based on historical and current data. These…
Q: Lissette Jones, the materials manager for an upscale retailer,wants to measure her customer service…
A: The number of times a customer receives the different quality of services is called the customer…
Q: a) Is there a strong linear trend in sales over time? b) Fill in the table with what Bob and Sherry…
A: Using excel for performing regression with Sales as the dependent variable and period as independent…
Q: 6. Tread-On-Us Carpet & Tile Company sold 700,000 square t.et of carpet last year, 800,000 square…
A: Moving average is a method of forecasting. It is calculated by adding up all the data points of a…
Q: firm produces three products , A , B and C , for sale both in the domestic market and in the export…
A: The Projected Profit is the excess of Projected Sales over Projected Production Cost. Project…
Q: Given this frequency distribution, what demand values would be associated with the following random…
A: Given, Demand Frequency 0 18 1 15 2 18 3 49 Cumulative frequency and its probability:…
Q: 4.27 Mark Cotteleer owns a company that manufactures sail- boats. Actual demand for Mark's sailboats…
A: Given - Forecasted demand of 2009 = 5,600 sailboats Season 2004 2005 2006 2007 Winter 1400…
Q: Problem 1 Consider the following simplex tableau. Row z xị r2 13 T4 15 16 17 rs RHS BV 1 0 -5 4 -1…
A: Given- Simplex Tableau-
Q: • 4.33 Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as…
A: a) Using excel for performing regression with Sales as the dependent variable and period as…
Q: 7. Freight car loadings over a 12-year period at a busy port are as follows: Week Number Week Number…
A: Given data: Week Number 1 220 2 245 3 280 4 275 5 300 6 310 7 350 8 360 9 400…
Q: Assignment What if we use a 3-month simple moving average? Kroger sells (among other stuff) bottled…
A:
Q: Which of the following method is used for calculating Time value of Money? a. Future Value b.…
A: Investors and economic managers utilize future value (FV) to predict how much an expenditure created…
Q: Mr. Meadows Cookie Company makes a variety of chocolate chip cookies inthe plant in Albion,…
A: Given data Demand for the next four-month Year Demand (thousands of cookies) 1 850 2 1260…
Q: 2) NaserCo Wants to display it products within 10,000 feet square according to the following Data:…
A: Let, A = Number of units of product A in display B = Number of units of product B in display C =…
Q: George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats…
A: The concept used here is forecasting using the Seasonal index method.
Q: 1 demand of cotton(intones) by Westham textile S.C are shown below 1 2 3 4 7 8 year Actual 10 11 13…
A: Note: Since you have posted multiple parts in the same questions, we will be answering the first…
Q: Determine the Forecast Error for the data below using the Mean Absolute Deviation (MAD) formula.…
A: Mean absolute deviation or MAD is the mean or average value of the forecast deviation of error for a…
Q: Determine the Forecast Error for the data below using the Mean Absolute Percentage Error (MAPE)…
A: Error = Demand - Forecast Absolute Error = Positive value of Error Percent Error = (Absolute error…
Q: In the cash count made on 10.05.202, a cash balance of 35,000 TL was determined. As of the same…
A: The correct option will be - D) 397 Count and Receipt Surplus Hs. 5,000 TL (Creditor)…
Q: George Kyparisis owns a company that manufactures sailboats. Actual demand for George's sailboats…
A: Calculation of average sales for each season: Season 1 2 3 4 Average Winter 1400 1200 1000 960…
Q: Assuming actual product demand were 1,500; 1540; 1,520; 1,550; and 1,560 for Weeks 1, 2, 3, 4, and…
A: Forecasting is the process of estimating the future demand using previous or historic data or…
Q: b. Compute a tracking signal for periods 5 through 14 using the initial and updated MADS. (Negative…
A:
Q: Below are the production demands for the first four months of the year. What is the 4 month moving…
A: Forecasting is the process of estimation in which future demand is predicted based on previous or…
Q: PROBLEM 2:The manager of a large manufacturer of industrial pumps prepare forecasts for a six- month…
A: Formula:
Q: Develop a decision table for this decision
A: Below is the solution:-
Q: If we use a simple exponential smoothing method with ??=0.3, ??11=100 and ??12=120, what is your…
A: Inventory management is the management in which raw materials and finished products are stored and…
Q: QUIZ NO.3 4. Joseph Biggs owns his own ice cream truck and lives 30 miles from a Florida beach…
A: Decision tree: A Decision tree is a quantitative tool in order to aid in decision making processes,…
Q: Use the data below to solve for the following: 2. Naïve method 3. Unweighted 3 month moving average…
A: 2. Naïve techniqueThe simplest form of forecasting, the naive method forecasts that the value in the…
Q: Exponential Smoothing, Exponentially Smoothed MAD, and Tracking SignalThe XYZ Company was flooded by…
A: Formula:
Q: Problem: Sales of industrial vacuum cleaners at Yarena Supply CO. over the past 13 months are as…
A:
Q: a. A manufacturing firm manufactures electric motors. The sales during the last four months…
A: The mean absolute deviation is extremely high with a worth of 18.85% and this leads to extreme…
Q: The following table is given. What is the demand forecast for period 13 if the Winter model is used?…
A: Given data: Demand forecast for 8th period = 7056 Trend forecast for 8th period = 227 Observing the…
Q: Sales in P1,000 Month Sales in P1,000 Month 11 January 14 August 14 February 17 September…
A: Given, Month Sales in P (1,000) January 11 February 14 March 15 April 10 May 15…
Q: Period (t) Enrollment (1000s) 1 6.5 2 8.1 3 8.4 4 10.2 5 12.5 6 13.3 7 13.7 8 17.2 9 18.1 Develop a…
A: Note: - Since we can answer only up to three subparts we will answer the first three subparts…
Q: The historical data for 4 perlods demand are 65, 60, B0, ond 70respectively Calculate the weighted…
A: Demand for period 4 = 70Demand for period 3 = 80Weights = (0.4, 0.6)In weighted moving average,…
Q: Fit a linear trend equation by the method of least squares. Determine the predicted value of trend…
A: The provided data can be considered as year on X-axis and Production on Y-axis.
Q: The Hickory Company manufactures wooden desks. Management schedules overtime every weekend to reduce…
A: First Come First Served (FCFS) and Earliest Due Date (EDD) are the two ways to determine work flow…
Q: Tropical Seafoods is a small new restaurant that has opened in town. Sales have been steadily…
A: Weighted moving average is 43 MAD is 4 MSE is 26 and MAPE is 12
Q: You have the data on the application during the 8 consecutive year period below Wanted / Find the…
A: Given that: Year Demand 2000 24 2001 48 2002 50 2003 68 2004 60 2005 66 2006 70…
Q: The following data relate to the price of rice per kg.in different years. year 1998 1999 2000…
A:
Q: 1. A commercial bakery has recorded sales (in dozens) for three products, shown as…
A: Formula:
Q: Given an actual demand this period of 143, a forecast value for this period of 119, and an alpha of…
A: Exponential smoothing is a period arrangement gauging strategy for univariate information that can…
Q: 1 demand of cotton(intones) by Westham textile S.C are shown below year 1 2 3 4 6 7 8 Actual demand…
A: Given information, Year Actual Demand 1 10 2 11 3 13 4 15 5 14 6 16 7 18 8 20
Q: The following gives the number of pints of type Bblood used a t Woodlawn Hospital in the past 6…
A: The formulas to be used are as follows: 3-week moving average= sum of previous 3 week pints/number…
Q: 12.4. The chairperson of the department of management at Tech wants to forecast the number of…
A: Given data is
Q: 3. National Mixer, Inc., sells can openers. Monthly sales for a seven-month period were as follows:…
A: Note: - Since we can answer only up to three subparts we will answer the first three subparts (a, b…
help with D and E, I need it in excel please
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- In Example 11.1, the possible profits vary from negative to positive for each of the 10 possible bids examined. a. For each of these, use @RISKs RISKTARGET function to find the probability that Millers profit is positive. Do you believe these results should have any bearing on Millers choice of bid? b. Use @RISKs RISKPERCENTILE function to find the 10th percentile for each of these bids. Can you explain why the percentiles have the values you obtain?The below is an extract from the fixed asset register of ABC Ltd as at 31 December 2019Date of PurchaseCostuseful lifeLand1-Jan-306,000,000.000Building28-Feb-172,000,000.0020Vehicle:650,000.00Toyota Hilux1-Oct-19 350,000.005Ford Ranger30-Jun-17 300,000.005Furniture and Fittings1-May-20150,000.002Activities throughout the 2020 Financial Period:1. New Machinery have been purchased on 01 April 2020 at a Cost of N$ 4000,000. The machinery has been installed on the 15 April 2020 and was available for use on the 01 May 2020. Machinery is the only property plant and equipment of the company that is measured according to the revaluation method.1.1. On the 30th of October 2020 management decided to revalue the machinery due to a drastic decline in the revenue from sale of machinery produced inventory.Net replacement cost for the machine as at the 30th of October 2020 is N$2 000 000.2. The Toyota Hilux was involved in an accident on 1 October 2020 due to the floods and was written off by the…Grey Manufacturing Company expects sales to total 13,000 units in the first quarter, 12,000 units inthe second quarter, and 15,000 units in the third quarter of the current fiscal year. Company policyis to have on hand at the end of each quarter an amount of inventory equal to 10% of the followingquarter’s sales. Given this information, how many units should be scheduled for production in thesecond quarter?
- A firm has revenue function given by R=10Q where R=Gross Revenue and Q=Numberof Units Sold, Production Cost function is given byC = 20000+ 50(Q/800)^2Find:(i) the total Profit function, and(ii) the number of Units (Q) to be sold to get the maximum Profit4. Spears Rowbuck has recorded the following sales figures. Calculate the seasonal indices for Thursday and Friday. Week 1 Week 2 Week 3 Week 4 Monday 43 51 40 66.0 Tuesday 45 41 57 58.6 Wednesday 22 37 30 34.7 Thursday 25 22 33 36.7 Friday 31 25 37 25.0 a. Thursday = 29.18, Friday = 29.50 b. Thursday = 0.2074, Friday = 1.1632 c. None of the other options. d. Thursday = 0.7678, Friday = 0.7763 e. Thursday = 0.6142, Friday = 0.62119.5 Capital Healthplans Inc. is evaluating two different methods for providing home health services to its members. Both methods involve contracting out for services, and the health outcomes and revenues are not affected by the method chosen. Therefore, the net cash flows for the decision are all outflows. Here are the projected flows: Year Method A ($) Method B ($) 0 (300,000) (120,000) 1 (66,000) (96,000) 2 (66,000) (96,000) 3 (66,000) (96,000) 4 (66,000) (96,000) 5 (66,000) (96,000) What is each alternative’s IRR? If the opportunity cost of capital for both methods is 9 percent, which method should be chosen? Why?
- 5. Daniel is planning to earn money over the summer mowing lawns in the neighborhood to buy a scooter. The scooter he wants costs $2,200. He will be charging $19.1/lawn and estimates his costs to be $2.7/lawn. How many lawns must he mow in order to pay for the scooter entirely through his earnings? a. 115.18 b. None of the other options. c. -134.15 d. 134.15 e. 112.48 f. 2562.20A retired couple supplement their income by making fruit pies, which they sell to a local grocery store. During the month of September, they produce apple and grape pies. The apple pies are sold for $1.50 to the grocer, and the grape pies are sold for $1.20. The couple is able to sell all of the pies they produce owing to their high quality. They use fresh ingredients. Flour and sugar are purchased once each month. For the month of September, they have 1,200 cups of sugar and 2,100 cups of flour. Each apple pie requires 1 1⁄2 cups of sugar and 3 cups of flour, and each grape pie requires 2 cups of sugar and 3 cups of flour. a. Determine the number of grape and the number of apple pies that will maximize revenues if the couple working together can make an apple pie in six minutes and a grape pie in three minutes. They plan to work no more than 60 hours. b. Determine the amounts of sugar, flour, and time that will be unused.1.A clockmaker makes two types of woodenclocksto sell at various malls. It takes him three hours to assemble a pine clock, which requires two oz of varnish. It takes four hours to assemblea molave clock, which takes four oz of varnish. He has eight oz of varnish available in stock and can work 12 hours. If he makes a P100 profit on each pine clock and P120 on each molave clock, how many of each type should he make to maximize his profit?2.A biologist is developing two new strains of bacteria. Each sample of Type A bacteria produces five new viable bacteria,and each Type B bacteria produces six new viable bacteria. Altogether, at least 150 new viable bacteria must be produced. At least 10, but not more than 20,of the original sample,must be Type A,and not more than 60 of the samples must be Type B. A sample of Type A costs P500,and a sample of Type B costs P700. If both types are to be used, how many samples of each type should be used to minimize the cost?
- A retired couple supplement their income by making fruit pies, which they sell to a local grocery store. During the month of September, they produce apple and grape pies. The apple pies are sold for $10.00 to the grocer, and the grape pies are sold for $8.00. The couple is able to sell all of the pies they produce owing to their high quality. They use fresh ingredients. Flour and sugar are purchased once each month. For the month of September, they have 1,500 cups of sugar and 2,400 cups of flour. Each apple pie requires 1½ cups of sugar and 3 cups of flour, and each grape pie requires 2 cups of sugar and 3 cups of flour. a. Determine the number of grape and the number of apple pies that will maximize revenues if the couple working together can make an apple pie in 6 minutes and a grape pie in 3 minutes. They plan to work no more than 60 hours. (Round your answers to nearest whole number.) b. Determine the amounts of sugar, flour, and time that will be unused. (Leave no cells blank -…Ning Caterers quotes a price of P940.80 per person for a banquet dinner. This priceincludes the 12% VAT and 20% service charge. The VAT is computed based on thefood’s selling price plus the service charge. The service charge is computed based onthe food’s selling price only. At what amount does Ning Caterers price the food?a. P710.77 c. P613b. P700.00 d. P840 show the solution pleaseA company manufactures two products. If it charges aprice pi for product i, it can sell qi units of product i, whereq1 60 3p1 p2 and q2 80 2p2 p1. It costs $25to produce a unit of product 1 and $72 to produce a unit ofproduct 2. How many units of each product should beproduced to maximize profits?