The Entson Company Believes that its monthly sales during the period from November of the current year
Fantastic news! We've Found the answer you've been seeking!
Question:
The Entson Company Believes that its monthly sales during the period from November of the current year to July of next year are normally distributed with the mean and standard deviation given in the table.
Transcribed Image Text:
The Entson Company believes that its monthly sales during the period from November of the current year to July of next year are normally distributed with the means and standard deviations given in Table 11.2. Each month Entson incurs fixed costs of $250,000. In March taxes of $150,000 and in June taxes of $50,000 must be paid. Dividends of $50,000 must also be paid in June. Entson estimates that its receipts in a given month are a weighted sum of sales from the current month, the previous month, and two months ago, with weights 0.2, 0.6, and 0.2. In symbols, if R, and S, represent receipts and sales in month t, then R, = 0.2S, 2 + 0.6S, + 0.2S, (11.1) The materials and labor needed to produce a month's sales must be purchased one month in advance, and the cost of these averages to 80% of the product’s sales. For example, if sales in February are $1,500,000, then the February materials and labor costs are $1,200,000, but these must be paid in January. Table I1.2 Monthly Sales (in Thousands of Dollars) for Entson Nov. Dec. Jan. Feb. Mar. Apr. May Jun. Jul. Mean 1500 1600 1800 1500 1900 2600 2400 1900 1300 Standard Deviation 70 75 80 80 100 125 120 90 70 At the beginning of January, Entson has $250,000 in cash. The company wants to ensure that each month's ending cash balance never falls below $250,000. This means that Entson might have to take out short-term (one-month) loans. For example, if the ending cash bal- ance at the end of March is $200,000, Entson will take out a loan for $50,000, which it will then pay back (with interest) one month later. The interest rate on a short-term loan is 1% per month. At the beginning of each month, Entson earns interest of 0.5% on its cash balance. The company wants to use simulation to estimate the maximum loan it will need to take out to meet its desired minimum cash balance. Entson also wants to analyze how its loans will vary over time, and it wants to estimate the total interest paid on these loans. The Entson Company believes that its monthly sales during the period from November of the current year to July of next year are normally distributed with the means and standard deviations given in Table 11.2. Each month Entson incurs fixed costs of $250,000. In March taxes of $150,000 and in June taxes of $50,000 must be paid. Dividends of $50,000 must also be paid in June. Entson estimates that its receipts in a given month are a weighted sum of sales from the current month, the previous month, and two months ago, with weights 0.2, 0.6, and 0.2. In symbols, if R, and S, represent receipts and sales in month t, then R, = 0.2S, 2 + 0.6S, + 0.2S, (11.1) The materials and labor needed to produce a month's sales must be purchased one month in advance, and the cost of these averages to 80% of the product’s sales. For example, if sales in February are $1,500,000, then the February materials and labor costs are $1,200,000, but these must be paid in January. Table I1.2 Monthly Sales (in Thousands of Dollars) for Entson Nov. Dec. Jan. Feb. Mar. Apr. May Jun. Jul. Mean 1500 1600 1800 1500 1900 2600 2400 1900 1300 Standard Deviation 70 75 80 80 100 125 120 90 70 At the beginning of January, Entson has $250,000 in cash. The company wants to ensure that each month's ending cash balance never falls below $250,000. This means that Entson might have to take out short-term (one-month) loans. For example, if the ending cash bal- ance at the end of March is $200,000, Entson will take out a loan for $50,000, which it will then pay back (with interest) one month later. The interest rate on a short-term loan is 1% per month. At the beginning of each month, Entson earns interest of 0.5% on its cash balance. The company wants to use simulation to estimate the maximum loan it will need to take out to meet its desired minimum cash balance. Entson also wants to analyze how its loans will vary over time, and it wants to estimate the total interest paid on these loans.
Expert Answer:
Answer rating: 100% (QA)
Beginning from the spreadsheet created by following the steps in example 116 the fir... View the full answer
Posted Date:
Students also viewed these general management questions
-
The lengths of pregnancies are normally distributed with a mean of 268 days and a standard deviation of 15 days. a. If one pregnant female is randomly selected, find the probability that her length...
-
The lengths of pregnancies are normally distributed with a mean of 268 days and a standard deviation of 15 days. a. One classical use of the normal distribution is inspired by a letter to Dear Abby...
-
The durations of pregnancies are normally distributed with a mean of 268 days and a standard deviation of 15 days. If we stipulate that a baby is premature if the length of pregnancy is in the lowest...
-
Compare the hoop stress (r,/2) predictions from elasticity with voids given by relation (15.5.18) with the corresponding results from classical theory. Choosing N = 1/2 and L = 2, for the elastic...
-
During the Reagan era, 19811988, the U.S. current account moved from a tiny surplus to a large deficit. The following table provides U.S. macroeconomic data for that period. a. Based on these data,...
-
The following bond investment transactions were completed during 2014 by Starks Company: Jan. 31. Purchased 75, $1,000 government bonds at 100 plus 30 days' accrued interest. The bonds pay 6% annual...
-
Victory Athletic Supply (VAS) makes game jerseys for athletic teams. The F. C. Strikers soccer club has offered to buy 100 jerseys for the teams in its league for $15 per jersey. The team price for...
-
Mario Company experienced the following events: 1. Purchased merchandise inventory for cash. 2. Sold merchandise inventory on account. Label the revenue recognition 2a and the expense recognition 2b....
-
A tree on a hillside casts a shadow c ft down the hill. If the angle of inclination of the hillside is b to the horizontal and the angle of elevation of the sun is a, find the height of the tree....
-
You work in the human resources department of your company helping new employees fill out the necessary paperwork to get their first paycheck. There are a number of decisions that employees must make...
-
The following information is for Donald's Logistics Company: Cash balance per bank, July 31, $7,140. July bank service charge not recorded by the depositor, $44. Cash balance per books, July 31,...
-
Write a java program to find out all the pairs of Integer elements in array whose sum is equals to given number?
-
4. If P 28 N, and moves at a constant velocity. a. Calculate FN b. Calculate f c. Calculate 280 P 30 N 2.0kg
-
Precondition: L is a nonempty list of integers. Postcondition: Return the indices a and b that give the longest strictly increasing sublist 1[a:b] of L. maxSublist (L): 1. a = 0; current = 0; i = 1;...
-
What is strategic management? What is strategic planning? What is strategic thinking? What is the difference between strategic planning, strategic management and strategic thinking? How are strategic...
-
Prepare a financial analysis of this company and comment on its status and performance. Assets Owner's Equity Liabilities and Cash $ 1,000 A/P $90,000 A/R 6,500 LT Debt 100,000 Inventory 112,500...
-
Bookmarks PDF Converter - Co... Kenneth C. Davis -... Payroll Hourly Payc... D2L Login - Xavier Uni- Chapter 19 Assessment i 1 Part 1 of 4 5 points Required information Required 1 3 4 and 5 Required...
-
The unadjusted trial balance of Secretarial Services is as follows: SECRETARIAL SERVICES Unadjusted Trial Balance as at 31 December 2017 Account Debit Credit Cash at bank Office supplies Prepaid...
-
Jud's Manufacturing Company produces one product, Kebo. Because of wide fluctuations in demand for Kebo, the Assembly Department experiences significant variations in monthly production levels. The...
-
Lorch Company uses budgets in controlling costs. The May 2002 budget report for the company's Packaging Department is as follows. The budget amounts in the report were on the master budget For the...
-
Lakem elder Dutch manufactures expensive watch eases sold as souvenirs. Three ol its sales departments are: Retail Sales, Wholesale Sales, and Outlet Sales. The Retail Sales Department is a profit...
Study smarter with the SolutionInn App