Not all the items in your office supply store are evenly distributed as far as demand is concerned, so you decide to forecast demand to help plan your stock. Past data for legal-sized yellow tablets for the month of August areA)Using a three-week moving average, what would you forecast the next week to be? (Round your answer to the nearest whole number.)
B)Using exponential smoothing with ? = 0.20, if the exponential forecast for week 3 was estimated as the average of the first two weeks [(315 + 415)/2 = 365], what would you forecast week 5 to be? (Round your answer to the nearest whole number.)
Week 1 315
Week 2 415
Week 3 615
Week 4 715

Answers

Answer 1
Answer:

Answer: A. 582 ; B. 475

Explanation:

A. Three week moving average

three moving average requires us to take the last three weeks forecast in     calculating the forecast for following week,  to calculate week 5 forecast we will start from week 2 to week 4.

 Week 2 = 415

 Week 3 = 615

 Week 4 = 715

Three week moving average = (WEEK 2 + Week 3 + Week 4)/N

Three week moving average = (415 + 615 + 715)/3  

Three week moving average =  1745/3 = 581.6667 = 582

using three week moving average the forecast for week 5 is 582

B.Exponential smoothing

Exponential smoothing forecast for week 3 is 365, to calculate the forecast of week 5 we need to find a forecast for week 4 first using exponential  smoothing

S = smoothing Factor = 0.2

D = most recent forecast (week 3) = 615

F = most recent forecast under exponential smoothing = 365

Forecast(week 4) = (D × S) + (F × (1 - S))

Forecast(week 4) = (615 × 0.20) + (365 × (1 - 0.20))

Forecast(week 4) = 123 + 292 = 415

The forecast for week 4 using exponential smoothing is 415

Week 5 forecast calculation

S = smoothing Factor = 0.2

D = most recent forecast (week 4) = 715

F = most recent forecast under exponential smoothing = 415

Forecast(week 5) = (D × S) + (F × (1 - S))

Forecast(week 5) = (715 × 0.20) + (415 - (1 - 0.20))

Forecast(week 5) = 143 + 332= 475

forecast for week 5 is 475

Answer 2
Answer:

Final answer:

The forecast for the next week using a three-week moving average would be 448 items. Using exponential smoothing with a smoothing constant of 0.20, the forecast for week 5 would be 435 items.

Explanation:

To answer both parts of your question:

A) The three-week moving average is calculated by taking the average of the past 3 weeks, so for week 4, it would be the average of weeks 1, 2, and 3: [(315 + 415 + 615)/3 = 448]. Therefore, the forecast for week 4 using a three-week moving average would be 448 items, rounded to the nearest whole number.

B)Exponential smoothing requires the use of a smoothing constant, in this case, ? = 0.20, and the previous actual and forecasted values. Using the given exponential forecast for week 3 of 365, the forecasted demand for week 5 would be calculated as follows: Forecast = ? * Actual_previous + (1-?) * Forecast_previous = 0.20 * 715 + (1-0.20) * 365 = 435. Therefore, your week 5 forecast would be 435 items, rounded to the nearest whole number.

Learn more about Demand Forecasting here:

brainly.com/question/32509592

#SPJ3


Related Questions

Elie Company purchased a building with a market value of $ 295 comma 000 and land with a market value of $ 45 comma 000 on January​ 1, 2018. Elie Company paid $ 40 comma 000 cash and signed a 20​-year, 6​% mortgage payable for the balance. Requirements: 1. JournalizetheJanuary1,2018,purchase. 2. Journalize the first monthly payment of $3,370 on January 31, 2018. (Round to the nearest dollar.)
Stoltenberg Co. had the following information for the month of June: Work in process beginning inventory, June 1 2100​ units Units transferred in 16,300​ units Work in process ending inventory, June 30 4100​ unitsBeginning work-in-process inventory is 30 percent complete as to conversion. Ending work-in-process inventory is 50 percent complete as to conversion. Materials are added at the end of the process.How many units were completed in June?The equivalent units for materials under the weighted-average method are calculated to be?
Markson Company had the following results of operations for the past year: Sales (8,000 units at $20) $ 160,000 Variable manufacturing costs $ 86,000 Fixed manufacturing costs 15,000 Variable administrative expenses 12,000 Fixed selling and administrative expenses 20,000 (133,000 ) Operating income $ 27,000 A foreign company offers to buy 2,000 units at $14 per unit. In addition to variable manufacturing and administrative costs, selling these units would increase fixed overhead by $1,600 for the purchase of special tools. Markson’s annual productive capacity is 12,000 units. If Markson accepts this additional business, its profits will:
The adjusted trial balance of Sunland Company shows these data pertaining to sales at the end of its fiscal year, October 31, 2022: Sales Revenue $903,400; Freight-Out $13,700; Sales Returns and Allowances $22,000; and Sales Discounts $15,400. Prepare the sales section of the income statement.
Woodman Company uses a predetermined overhead rate based on direct labor-hours to apply manufacturing overhead to jobs. Estimated and actual data for direct labor and manufacturing overhead for last year are as follows: Estimated ActualDirect Labor Hours: 600,000 550,000 Manufacturing Overhead Estimated $720,000 $680,000

Alton Company produces metal belts. During the current month, the company incurred the following product costs: Raw materials $100,000; Direct labor $75,000; Electricity used in the Factory $25,000; Factory foreperson salary $3,750; and Maintenance of factory machinery $2,000. Alton Company's indirect product costs totaled:

Answers

Answer:

Total indirect product costs                        $30,750

Explanation:

The indirect product costs refer to all the costs that are associated with the manufacturing overheads and can be calculated as follows:

Electricity used in the Factory                   $25,000

Factory foreperson salary                          $3,750

Maintenance of factory machinery            $2,000

Total indirect product costs                        $30,750

At the beginning of the year, a firm has current assets of $328 and current liabilities of $232. At the end of the year, the current assets are $493 and the current liabilities are $272. What is the change in net working capital?

Answers

Answer:

$125

Explanation:

Computation for the change in net working capital

Using this formula

Change in net working capital =( Ending Current asset- Ending Current liabilities) - (Beginning Current asset- Beginning Current liabilities)

Let plug in the formula

Change in net working capital =

($493 – $272) – ($328 – $232)

Change in net working capital = $221-$96

Change in net working capital =$125

Therefore the Change in net working capital will be $125

David and Lilly Fernandez have determined their tax liability on their joint tax return to be $1,700. They have made prepayments of $1,500 and also have a child tax credit of $2,000, of which $1,400 is refundable.What is the amount of their tax refund or taxes due?

Answers

Answer:

-$1,800

Explanation:

Given that

Tax liability = $1,700

Prepayment made = $1,500

Child tax credit = $2,000

The computation of tax refund is given below:-

= Tax liability - (Prepayment made + Child tax credit)

= $1,700 - ($1,500 + $2,000)

= $1700 - $3500

= -$1,800

Therefore, from the above calculation simply we subtract tax liability from prepayment and child tax credit.

The per-unit standards for direct labor are 2 direct labor hours at $15 per hour. If in producing 1800 units, the actual direct labor cost was $48000 for 3000 direct labor hours worked, the total direct labor variance is: a. $6000 unfavorable. b. $1800 unfavorable. c. $3750 unfavorable. d. $6000 favorable.

Answers

Answer:

The correct answer is D.

Explanation:

Giving the following information:

The per-unit standards for direct labor are 2 direct labor hours at $15 per hour. If in producing 1800 units, the actual direct labor cost was $48000 for 3000 direct labor hours worked.

We need to calculate the total direct labor variance, using two formulas:

Direct labor efficiency variance= (SQ - AQ)*standard rate

Direct labor efficiency variance= (1,800*2 - 3,000)*15= $9,000 favorable

Direct labor rate variance= (Standard Rate - Actual Rate)*Actual Quantity

Direct labor rate variance= (15 - 48,000/3,000)*3,000= $3,000 unfavorable

Total direct labor variance= 9,000 - 3,000= $6,000 favorable

2.) Which of the following is true? A. The convenience yield is always positive or zero. B. The convenience yield is always positive for an investment asset. C. The convenience yield is always negative for a consumption asset. D. The convenience yield measures the average return earned by holding futures contracts.

Answers

Answer:

The correct answer is letter "A": The convenience yield is always positive or zero.

Explanation:

The convenience yield reflects the premium of possessing an asset instead of one of its derivates or contracts. This situation arises in front of inverted markets, where holding the asset itself may bring more profits than purchasing a derivate of the same asset.

The convenience yield tends to be positive or zero because the prices of assets cannot fall below zero. In other words, they are not negative.

Final answer:

convenience yield is a benefit of owning a physical asset over a futures contract. The yield is typically positive or zero. In the context of investment and consumption assets, the yield assumptions may vary.

Explanation:

The question is focusing on the concept of convenience yield in finance and its relationship with investment and consumption assets. Convenience yield is the non-monetary advantage or benefit that a holder gets from owning a physical good or an asset over a futures contract on that asset. If you decide to hold an asset as opposed to a futures contract on the asset, it means because the net benefits – that is the benefits from holding the asset, minus the benefits of holding the contract – must be nonzero. Therefore, option A is correct: The convenience yield is always positive or zero.

Moreover, for an investment asset, which is purchased with the hope that it will generate income or appreciate in value, the convenience yield is generally assumed to be zero because holding it delivers no utility beyond the financial returns it provides. So option B is not always true. The convenience yield being negative for a consumption asset, an asset purchased for current use, is also unlikely (option C is incorrect). Such a negative value would suggest that owning the asset is somehow disadvantageous - which contradicts the reason for purchasing a consumption asset. Lastly, the convenience yield does not measure the average return earned on futures contracts, therefore option D is also incorrect.

Learn more about convenience yield here:

brainly.com/question/34770333

#SPJ3

The independent cases are listed below includes all balance sheet accounts related to operating activities: Net income Depreciation expense Accounts receivable increae 100,000 (200,000) (20,000) Case ACase B Case C $310,000 15,000 $420,000 40,000 150,000 80,000 (decrease) Inventory increase (decrease) Accounts payable increase (50,000) (50,000) 120,00070,000 60,000 (220,000) (40,000) 35,000 50,000 decrease) Accrued liabilities increase (decrease) Show the operating activities section of cash flows for each of the given cases (Amounts to be deducted should be indicated with a minus sign.) Case A Case B Case C Net Income Adjustments to Reconcile Net Income to net Cash provided by operating activities Depreciation Changes in Assets and Liabilities Accounts Receivable Inventory Accounts Payable Accrued Liabilities Net Cash Provided by OperatingActivities

Answers

Answer: Please see below

Explanation: The values from  the question are scattered, but here is how they should appear

                                                    Case A       Case B         Case C  

Net income                               $310,000         15,000 $420,000    

Depreciation expense                  40,000   150,000       80,000

Accounts receivable increase

(decrease                                      100,000 (200,000) (20,000)

Inventory increase (decrease)        (50,000)   35,000   50,000

Accounts payable increase           (50,000)   120,000   70,000

Accrued liabilities increase

(decrease)                                  60,000  (220,000) (40,000)

To calculate the operating activities section of cash flows for each of the given cases,

we use the Indirect method formula

Net cash flow from operating actvities  = Net Income + Non-Cash Expenses – Increase in Working Capital

Net cash flow from operating actvities =Net Income +/- Changes in Assets & Liabilities + Non-Cash Expenses

Net cash flow from operating actvities = Net Income + Depreciation + Stock Based Compensation + Deferred Tax + Other Non Cash Items – Increase in Accounts Receivable – Increase in Inventory + Increase in Accounts Payable + Increase in Accrued Expenses + Increase in Deferred Revenue

Following the formulae above, we can determine what expense should be added or subtracted to give the operating activities of cash flow below as

                                  Case A                   Case B               Case C

Net Income               $310,000                15,000         $420,000  

Net Income Adjustments to Reconcile Net Income to net Cash provided by operating activities

Depreciation                   40,000              150,000       80,000

Changes in Assets and Liabilities

Accounts Receivable        - 100,000       200,000           20,000

Inventory                              50,000           -35,000        - 50,000    

Accounts Payable            -50,000            120,000       70,000

Accrued Liabilities              60,000           - 220,000       -40,000

Net Cash Provided by Operating Activities

                                      $310,000         $230,000       $500,000