Auto sales at Carmen's Chevrolet are shown below. Using a 3-week moving average, what is the forecasted sales for month 7? note: write the rounded-off number (eg. "75" and NOT "75.17") Month Auto Sales 1 7 2 9 3 10 4 12 5 9 6 11 7 ???

Auto sales at Carmen's Chevrolet are shown below. Using a 3-week moving average, what is the forecasted sales for month 7? note: write the rounded-off number (eg. "75" and NOT "75.17") Month Auto Sales 1 7 2 9 3 10 4 12 5 9 6 11 7 ???

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

Revenue (£k) 200 175 150 125 100 75 50 25 0 73 96 130 149 Jan Feb 152 Mar Apr May 133 Jun Jul 140 Aug 145 Sep Oct Nov 150 Dec 155 Your manager has provided you with the revenue figures for last year. He has informed you that the target is to increase amount of products you sold in January last year by 50%. Based on the data provided, what would be your estimated target figure for this January? 178 200
Data for XYZ Co.• Expected sales volume: 2,250 units in the first quarter,with 250-unit increases in each succeeding quarter.• Sales price: $50 per unit. What was the total sales for each quarter?
The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 20 21 17 12 15 15 15 19 22 22 23 24 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method = sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = sales (round your response to two decimal places). The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied the most recent month = sales (round your response to one decimal place). Using exponential smoothing with a = 0.35 and a September forecast of 18.00, the forecast for the next period (Jan) = sales (round your response to two decimal places). Using a method of trend projection, the forecast for the next month (Jan) = sales (round your response to two decimal places). c) The method…
Why was the amount for December multiplied by 40 and the amount for January when its 40% of the prior month and 60% of the current?
Accounts Debit Credit Cash $24,300 Accounts Receivable 42,500 Allowance for Uncollectible Accounts $2,700 Inventory 42,000 Land 79,600 Accounts Payable 29,200 Notes Payable (8%, due in 3 years) 42,000 Common Stock 68,000 Retained Earnings 46,500 Totals $188,400 $188,400 The $42,000 beginning balance of inventory consists of 420 units, each costing $100. During January 2024, Big Blast Fireworks had the following inventory transactions: January 3 Purchase 1,050 units for $115,500 on account ($110 each). January 8 Purchase 1,150 units for $132,250 on account ($115 each). January 12 Purchase 1,250 units for $150,000 on account ($120 each). January 15 Return 160 of the units purchased on January 12 because of defects. January 19 Sell 3,600 units on account for $576,000. The cost of the units sold is determined using a FIFO perpetual inventory system. January 22 Receive $529,000 from customers on accounts receivable. January 24 Pay $359,000 to inventory suppliers on accounts payable. January…
In 2016, the automobile Industry announced the average vehicle selling price was $44,466. Six years earlier, the average price was $28,480. hun What was the annual percentage Increase in vehicle selling price? (Do not round Intermediate calculations and round your final answer to 2 decimal places.) Annual percentage Increase in selling price %
Please don't give image format
Would the quarter total for desired ending inventory be 16,800 or the total of all 3 months? The same question for begining inventory, would it be 42,000 or 21,000?
Until recently, Augean Cleaning Products sold its products on terms of net 70, with an average collection period of 85 days. In an attempt to induce customers to pay more promptly, it has changed its terms to 1/10, EOM, net 70. Assume current sales of $100, costs of $90, an interest rate of 12%, and no defaults. Assume each month has 30 days and a year has 360 days. The initial effect of the changed terms is as follows: Percent of Sales with Cash Discount 70 Average Collection Periods (Days) Cash Discount 40a Net present value Net 90 Some customers deduct the cash discount even though they pay after the specified date. a. Calculate the NPV per $100 of sales based on the original terms. (Do not round intermediate calculations. Round your answer to 2 decimal places.)
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 >
The grocery industry has an annual inventory turnover of about 13 times. Organic Grocers, Inc., had a cost of goods sold last year of $11,310,000; its average inventory was $993,980. What was Organic Grocers' inventory turnover, and how does that performance compare with that of the industry? a) What was Organic Grocers' inventory turnover? times per year (round your response to two decimal places).
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