Problem 5The North Aurelius Elementary School's lunch customers are forecasted based on a movingaverage. The number of customers served by day for the first five weeks of the year are asfollows:MondayTuesdayWednesdayThursdayFriday142139041039844034303962425410415 406412385435 44554404024425415408410402406438 441Required:1. Forecast the number of meals for each day of the week six using the five-week movingaverage method.2. Forecast the number of meals for each day of week six using the three-week movingaverage method.3. Comment on the difference in the results of parts 1 and 2.

a. Week 6 using five week moving average 1 2 3 4 5 6 Monday 421 425 430 425 440 428…

Problem 5 The North Aurelius Elementary School's lunch customers are forecasted based on a moving average. The number of customers served by day for the first five weeks of the year are as follows: Monday Tuesday Wednesday Thursday Friday 421 390 410 398 440 2 425 410 415 412 435 3 430 396 406 385 445 4 425 415 408 402 438 5 440 402 410 406 441 Required: 1. Forecast the number of meals for each day of the week six using the five-week moving average method. 2. Forecast the number of meals for each day of week six using the three-week moving average method. 3. Comment on the difference in the results of parts 1 and 2.

Problem 5 The North Aurelius Elementary School's lunch customers are forecasted based on a moving average. The number of customers served by day for the first five weeks of the year are as follows: Monday Tuesday Wednesday Thursday Friday 421 390 410 398 440 2 425 410 415 412 435 3 430 396 406 385 445 4 425 415 408 402 438 5 440 402 410 406 441 Required: 1. Forecast the number of meals for each day of the week six using the five-week moving average method. 2. Forecast the number of meals for each day of week six using the three-week moving average method. 3. Comment on the difference in the results of parts 1 and 2.

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter15: Managing Short-term Assets

Section: Chapter Questions

Problem 14PROB

See similar textbooks

Similar questions

Assuming that the average customer ticket is $6, determine: Number of customers per day the first month they are open (January) __________ Number of customers per day the 6th month they are open (June) __________ Number of customers per day the 12th month they are open (December)________
1. Malinao Bakery forecast sales 2100 loaves of bread for the month ofJanuary. The owner would like to maintain 150 loaves of bread in itsending inventory at the end of each month. The beginning inventory at thestart of January is 50 loaves of bread. How many loaves of bread shouldMalinao Bakery produce for January?A. 2,300 loaves C. 2,200 loavesB. 2,050 loaves D. 2,250 loaves 2. If the projected or forecasted sales of Malinao Bakery for the month of Januaryis 2100 loaves of bread, beginning inventory 50 loaves and the selling price isP50 per loaves. How much are the projected sales in peso of Malinao Bakeryfor January?A. P100,000. C. P107,500.B. P100,500. D. P105,000. 3. What is the possible suggestion of the Accountant or Financial Officer to theowner of the company, if there is excess cash above its required maintainingcash balance?A. Pay all creditsB. Buy brand new carC. Purchase additional machineD. Invest in short term investments to earn additional profits. 4.…
Help
BUS 038 : Business Computatns 11. You purchase goods on an invoice dated February 5 of a leap year, with terms of 5/10-90X. Calculate the last day of the discount period. The discount period ends 100 days (10 + 90 = 100) after the date of the invoice. February 5 is day 36.
Refer to Exercise 8.24. Del Spencers purchases clothing evenly throughout the month. All purchases are on account. On the first of every month, Jana Spencer, Dels wife, pays for all of the previous months purchases. Terms are 2/10, n/30 (i.e., a 2 percent discount can be taken if the bill is paid within 10 days; otherwise, the entire amount is due within 30 days). The forecast purchases for the months of May through September are as follows: Required: 1. Prepare a cash disbursements schedule for the months of August and September. (Round all cash amounts to the nearest dollar.) 2. Now, suppose that Del wants to see what difference it would make to have someone pay for any purchases that have been made three times per month, on the 1st, the 11th, and the 21st. Prepare a cash disbursements schedule for the months of July and August assuming this new payment schedule. (Round all cash amounts to the nearest dollar.) 3. Suppose that Jana (who works full-time as a school teacher and is the mother of two small children) does not have time to make payments on two extra days per month and that a temporary employee is hired on the 11th and 21st at 20 per hour, for four hours each of those two days. Is this a good decision? Explain. Del Spencer is the owner and founder of Del Spencers Mens Clothing Store. Del Spencers has its own house charge accounts and has found from past experience that 10 percent of its sales are for cash. The remaining 90 percent are on credit. An aging schedule for accounts receivable reveals the following pattern: 15 percent of credit sales are paid in the month of sale. 65 percent of credit sales are paid in the first month following the sale. 14 percent of credit sales are paid in the second month following the sale. 6 percent of credit sales are never collected. Credit sales that have not been paid until the second month following the sale are considered overdue and are subject to a 3 percent late charge. Del Spencers has developed the following sales forecast: Required: Prepare a schedule of cash receipts for August and September.
REQUIREMENT NUMBER 4&5
answer first and second sub parts please do it in excel
Mathematics 8. Malik Boykin is paid $8.20 per hour and time and a half for any work over 40 hours per week. Find his total hours and gross pay for each week. W Th F Week of 3/10 5.5 9. 12 7 Week of 3/17 8 8.5 13 4.5 4
A1
Problem #1. You have a Visa credit card account with a 26.49% annual percentage rate calculated on the average daily balance. The billing date is the first day of each month, and the billing cycle is the number of days in that month. Your credit card balance on April 1 was $552. On April 10th you made a $119 purchase. You made another purchase, a $25 gift card, on April 24th. You made a $150 payment on April 29th. Show your work for all parts of the problem. (a) What is the average daily balance for April? (b) What is your finance charge on the account as of May 1st? (c) What is your new credit card balance?
gageNOWv2 | Online teachin x akeAssignment/takeAssignmentMain.do?invoker=8&takeAssignmentSessionlocator=8inprogress=false eBook Show Me How Print Item Personal Budget At the beginning of the school year, Katherine Malloy decided to prepare a cash budoet for the months of September, October, November, and December. The budget must plan for enough cas on December 31 to pay the spring semester tuition, which is the same as the fall tuition The following information relates to the budget: $6,210 Cash balance, September 1 (from a summer job) 80 Purchase season football tickets in September 220 Additional entertainment for each month 3,400 Pay fall semester tuition in September 300 Pay rent at the beginning of each month 170 Pay for food each month 400 Pay apartment deposit on September 2 (to be returned December 15) 770 Part-time job earnings each month (net of taxes) a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an…
Question 2 Joan Zorba orders calculators for her office supply stores. Each calculator cost $35, currently she is ordering 230. Daily demand for these calculators is 5. The cost to re-order this item is estimated at $44, while the annual inventory holding cost is 22%. Orders are received two working days after an order is placed. The office operates 52 weeks per year, 5 days per week Determine the reorder point using EOQ. Greater than or equal to 43 and less than or equal to 49 Greater than or equal to 431 and less than or equal to 443 Greater than or equal to 2053 and less than or equal to 2064 Greater than or equal to 6 and less than or equal to 25 4 pts < Previous Next VIV