Sales of quilt covers at Bud Banis's discount department store in Carbondale over the past year are shown below. Management prepared a forecast using a combination of exponential smoothing and its collective judgment for the 4 months (March, April, May, and June): Month Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Unit Sales 102 97 96 112 120 120 92 84 100 96 88 112 Management's Forecast 125 116 108 108 a) MAD for the forecast developed by the management's technique = sales (round your response to two decimal places).

Sales of quilt covers at Bud Banis's discount department store in Carbondale over the past year are shown below. Management prepared a forecast using a combination of exponential smoothing and its collective judgment for the 4 months (March, April, May, and June): Month Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Unit Sales 102 97 96 112 120 120 92 84 100 96 88 112 Management's Forecast 125 116 108 108 a) MAD for the forecast developed by the management's technique = sales (round your response to two decimal places).

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Complete this question by entering your answers in the tabs below. 4 Required 1 Required 2 Prepare a schedule of forecasted sales, on a rolling basis, for the months January through June, inclusive. (Hint: There will be only one forecasted number for January-this is the forecast done in December. For February, there will be two forecasts: one done in December and a second done in January. For June, there will be six forecasts, one done in each of the preceding six months.) Month of Forecast for Month of Forecast January February March April May June December January • February March April May Required 1 Required 2 >
Management is planning to increase menu prices 4 percent and also expects a 3 percent increase in sales volume. Forecast food sales for months 1-3 by using the following historical information: Month Sales Volume Last Year Month 1 $140,000 Month 2 175,000 Month 3 190,000
Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows. Month Soles Forecast 1 Forecast 2 1 835 785 810 2 835 800 825 3 830 845 845 4 855 830 815 5 770 765 810 6 835 805 811 7 780 790 810 8 845 790 780 9 790 820 810 10 815 795 840 a. Compute the MSE and MAD for each forecast (Round your answers to 2 decimal places.) MSE MAD Forecast 1 Forecast 2
Please creat an Excel spreadsheet with the marketing expenses and revenue data for the previous 10 quartersB.Perform regression analysis to determine the relationship between marketing expenses and revenueC.Using the regression results, creat a graph that plots the data provided along with predicted revenue and 90% confidence interval linesD.Forecast revenue for the next quarter if marketing expenses are budgeted as follows:i.$55,000ii.$65,000iii.$75,000iv.$85,000E.Is this a good representational model? Quantify your answer
Please dont give solutions image based thanku
Management is planning to increase menu prices this year by 5 percent in Month 2 and another 3 percent in Month 4. Forecast food sales for months 1-6 this year by using the following historical information: Month Sales Volume Last Year Month 1 $140,000 Month 2 175,000 Month 3 190,000 Month 4 225,000 Month 5 265,000 Month 6 310,000
(J) please answer ASap... Question 1 The following table presents selected information for Superior Flooring's monthly production budgets for the coming year. Superior's inventory policy is to have ending inventory equal to 10% of the next month's sales. What is the beginning inventory in June? A. 350 B. 310 C. 250 D. 340 Question 2 Which of the following statements is true? A. A budget reconciliation report shows the difference between actual profit and budgeted profit and does not show the other variances. B. Activity-based costing is not used to evaluate customer profitability. C. Sales quantity (budgeted sales volume vs. actual sales volume) is the only item which differs between the master budget and the flexible budget. D. Comparing the flexible budget to the as-if budget isolates a change in input price (e.g. budgeted input price vs. actual input price). Question 3 Which of the following is not a benefit of budgeting? A. It reduces the need for analysis with regard to company…
5
Do not give solution in image formet
Budget for a merchandising company Nano,inc.is preparing its budget for the second quarter . The following sales data have been forecasted: April. May. June. June July U/sales. 640. 720. 780. 620. 660 Additional information follows: inventory on March 31: 192 units Desired ending inventory each month: 30% of next month's sales. How many units should be produced in April, May and June? How many units should be produced in the second quarter in total? You can Write your answers on this sheet as an excel table or a pasted word documentable.
It's Still Raining (ISR) manufacturers umbrellas. In order to better budget and manage costs, they are analyzing the purchasing costs behavior. They have the following data from the last six months of last year. Month Total Purchasing Costs Purchase Orders July $19,670 460 August $20,940 560 September $19,430 400 October $20,020 500 November $18,800 470 December $19,340 480 Using the regression analysis function in Excel, what are the expected costs if 520 purchase orders are processed? Please round your answer to the nearest whole dollar.
If the excel spreadsheet looked like this how would you set it up?