JET Case Problem Analysis
James, Ernie, and Terri decides to open a business named JET Copies after discovering that they will make nice profits from by establishing a copier business at State University. However, they discover that they have to tackle the problem of machine breakdown after raising loan of $18,000 from Terri's parent. The breakdown if not properly manage will lead to lost of revenue. They decide to buy a smaller version of copier machine for $8,000 to be used as a back up in case of a breakdown of the original machine. Before buying a back-up machine, they decide to estimate the lost revenue if they do not have a backup machine. If the lost revenue within a year is more than $12,000, it will be of a business advantage to purchase a back-up copier machine. (Taylor, 2011).
Objective of this paper is use stimulation model to investigate the lost revenue, days-to-repair ad interval between breakdowns of Jet Copies. The method assist in revealing the lost revenue that will occur due to a breakdown of the machine for 1 year.
The study also delivers the written explanation/description and Excel spreadsheet to the case problem.
The attached spreadsheet provides the answers to the question 1, 2, 3, and 4. The Appendix 1 also provides the copy of the excel spreadsheet.
5. "Description and Explanation of the model (days-to-repair, lost revenue interval between breakdowns, and putting it together)."
Interval between Breakdowns
Based on the continuous distribution information provided in the case study, the random distribution probability for the machine breakdowns varies between 0 and 6 weeks. The study stimulates random number to stimulate the interval between...
The strategy assists in generating number of breakdown. The study also generates cumulative number by adding number of weeks to get 52 weeks, which are the number of weeks in a year.
The stimulation process in the Excel spreadsheet is as follows:
The study stimulates the RN1 (Random Number 1) in B15:B42 using the =RAND ().
In column C, the formula =6*SQRT (B15) and the formula is copied into the cell C17:C42.
In the column D, the formula =D15+C17 are computed to stimulate the "Cumulative Number of Weeks" in the cells D17:D42.
Days-To-Repair
Information from the case study reveals the probability distribution for repair days as being delivered as follows:
Repair time
P (y)
y (days)
0.20
1
0.45
2
0.25
3
0.10
4
1.00
From the data provided above, the cumulative information is generated using the formula =A6+B6 in the cell B7, and the formula copy into the B8:B9. Thus, the cumulative information is as follows:
Cumulative
Repair time
P (y)
Probability
y (days)
0.20
0.00
1
0.45
0.20
2
0.25
0.65
3
0.10
0.90
4
1.00
The Random function is used in the Excel as the next step using the "RN2 (Random Number 2)" using the =RAND () function in the column E. In the E15:E42 cells leading to random…
We can see that there exists a liner correlation, which means that attendance has a direct impact on final grade of students. In order to built this function data from columns D3:D30 (attendance) and data from columns F3:F30 (final grade) from Spreadsheet 1 was tested using Linear regression formula of excel. Results for m-coefficient of y=mx+b linear equation is in cell C70 Data for graph sketching is in table E70:E86:F70:F86 Interval for function
Excel or FoxPro. FoxPro: Is it worth it? As a business manager, it is often my responsibility to decide if a certain software program is worth adding to our business' repertoire. In the case of FoxPro, one has to answer the question of whether it is worth the time and money it will cost to train staff members in its use. In my opinion, Excel is quite adequate for our needs. On the surface,
Excel Q's (TCOs 2, 3, 7 and 9) You currently work for a home improvement store. Your company is growing and is considering expansion. The company currently has three locations (East, West, and Central) in one state and wants to consider expanding within the same state. You have been presented with the sales figures for the last three years for each of your locations. Based on this information, you are tasked with
Nonlinear Optimization and Excel Solver Nonlinear optimization Optimization has been considered among the most essential areas of modern applied mathematics, with its applications being in various fields such as in economics, engineering, statistics, finance, medicine and management science. As much as most of the books have described the different aspects, Nonlinear Optimization tend to be the first comprehensive treatment that give opportunity for the graduate students as well as researchers to have
" The article also didn't show consistency with the outline and the actual progress of the user. It doesn't highlight the specific section on the outline (left side) so the user will be at a loss when he takes a break and return to the article a few minutes later. Of course, there is the page progress on the upper right corner but this is not a very useful progress
Excel "According to T-100 Domestic Market, the top seven airlines in the United States by domestic boarding in a recent year were Southwest Airlines with 81.1 million, Delta Airlines with 79.4 million, American Airlines with 72.6 million, United Airlines with 56.3 million, Northwest Airlines with 43.3 million, US Airways with 37.8 million, and Continental Airlines with 31.5 million. Using Excel, construct a pie chart and a bar graph to depict