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...
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
Pros of Online Classes Excelling in an online world Online classes have numerous pros and cons. In some cases, depending on the individual, the pros may outweigh the cons. For instance, the working class may find it advantageous to take online courses in order to meet scheduling mandates. He or she can plan to take classes around their work schedule and by doing so they can spend more time with family as
Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.
Get Started Now