Develop a simulation model to estimate the profits

Assignment Help Accounting Basics

Reference no: EM132638811

Question - You are a management accountant for REGENT ELECTRONICS, a retailer of computers. The monthly demand for the A1 model of computers follows a normal distribution with a mean of 350 and a standard deviation of 75. Your company purchases there computers for 1200 and sells them at $2,300. Demand that the company cannot meet is lost to its competitors.

No of units held at month end	Inventory cost per unit
0 to 200	$12
201 to 400	$18
401 and above	$25

It costs the company the following amounts for every computer held in inventory at the end of each month:

Currently, the company follows a policy where it places an order for 1,000 computers whenever the inventory at the end of a month falls below 100 units. Your supplier charges you an administration fee of $500 per order placed. Orders placed at the end of a month arrives at the beginning of the next month.

It is now the beginning of January 2020. The company has 400 units of A1 computers in inventory.

Required -

1. Develop a simulation model to estimate the profits that the company can expect to make over the next two years (i.e. total profits from Jan 2020 to Dec 2021).

2. Based on your model, what is the 95% confidence interval of the mean value of profits over the next two years?

3. Construct a suitable histogram to represent the frequency distribution of the range of profits over the next two years.

Reference no: EM132638811

Questions Cloud

Make a cost of goods manufactured and income statement : Make a Cost of Goods Manufactured, Income Statement. W.W. Phillips Company produced 4,000 leather recliners during the year. These recliners sell for $400 each.

Data collection and analysis : what would your intentions be with regard to the data collection and analysis and what would you expect the results to show?

Prepare report including capital budgeting and risk analysis : What is the projects after-tax NPV? Should the project proceed? Prepare a report including capital budgeting, risk analysis and comments.

Determine what is the market value of the equity : Total firm cash flows, which adds $100 million to the value of the firm. Now, what is the market value of the firm? What is the market value of the equity?

Develop a simulation model to estimate the profits : Develop a simulation model to estimate the profits that the company can expect to make over the next two years (i.e. total profits from Jan 2020 to Dec 2021)

Explain what a measure of central tendency is : Explain what a measure of central tendency is and how it is used in analying/ quantifying market research data

Why is it essential that market research plans : Why is it essential that market research plans demonstrate that they will collect information that will enable clear identification of customer needs

How do determine the amount of overhead to be allocated : How do determine the amount of overhead to be allocated to each type of product using labor hours as the allocation base. Assume 60,000 labor hours

What are the challenges in brand management : 1) All brands have a specific life span called the brand life cycle. Discuss about the brand life-cycles of Sperry Top-Sider with proper illustration.

User Account

All Pages