# Question

You have been asked to simulate the cash inflows to a toy company for the next year. Monthly sales are independent random variables. Mean sales for the months January through March and October through December are $80,000, and mean sales for the months April through September are $120,000. The standard deviation of each month’s sales is 20% of the month’s mean sales. Model the method used to collect monthly sales as follows:

• During each month a certain fraction of new sales will be collected. All new sales not collected become one month overdue.

• During each month a certain fraction of one-month overdue sales is collected. The remainder becomes two months overdue.

• During each month a certain fraction of two-month overdue sales is collected. The remainder is written off as bad debt.

You are given the information in the file S16_41.xlsx from past months. Using this information, build a simulation model that generates the total cash inflow for each month. Develop a simple forecasting model and build the error of your forecasting model into the simulation. Assuming that there are $120,000 of one month-old sales outstanding and $140,000 of two month-old sales outstanding during January, you are 95% sure that total cash inflow for the year will be between what two values?

• During each month a certain fraction of new sales will be collected. All new sales not collected become one month overdue.

• During each month a certain fraction of one-month overdue sales is collected. The remainder becomes two months overdue.

• During each month a certain fraction of two-month overdue sales is collected. The remainder is written off as bad debt.

You are given the information in the file S16_41.xlsx from past months. Using this information, build a simulation model that generates the total cash inflow for each month. Develop a simple forecasting model and build the error of your forecasting model into the simulation. Assuming that there are $120,000 of one month-old sales outstanding and $140,000 of two month-old sales outstanding during January, you are 95% sure that total cash inflow for the year will be between what two values?

## Answer to relevant Questions

The file S02_03.xlsx contains data from a survey of 399 people regarding a government environmental policy.a. Which of the variables in this data set are categorical? Which of these are nominal; which are ordinal?b. For each ...The file S02_13.xlsx contains the thickness (in centimeters) of 252 mica pieces. A piece meets specifications if its thickness is between 7 and 15centimeters.a. What fraction of mica pieces meets specifications?b. Are the ...Consider a device that requires two batteries to function. If either of these batteries dies, the device will not work. Currently there are two new batteries in the device, and there are three extra new batteries. Each ...A common decision is whether a company should buy equipment and produce a product in house or outsource production to another company. If sales volume is high enough, then by producing in house, the savings on unit costs ...A truck manufacturer produces the Off Road truck. The company wants to gain information about the discounted profits earned during the next three years. During a given year, the total number of trucks sold in the United ...Post your question

0