Inputs Yearly rental cost Other monthly fixed costs Cost per copy Charge per copy Days per...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Inputs Yearly rental cost Other monthly fixed costs Cost per copy Charge per copy Days per year Months per year Copies per copier per year Profit model Copiers rented (trial value) Daily demand (trial value) Copies made Annual profit $5,000 $400 $0.03 $0.10 365 12 100,000 3 1000 300,000 $1,200 Part (a) Use two-way data table (copies rented along the top, daily demand along the side) Use conditional formatting to highlight negative numbers and positive numbers in the table. 1 1,200 3 5 500 1000 1500 2000 -2800 -2800 -2800 -2800 Part (b) Create a Break-even example. Copiers Rented Daily Demand Copies Made Annual Profit 3 0 2 -2025 -800 -800 -800 -7025 1200 1200 1200 -12025 750 3200 3200 -17025 -4250 5200 5200 Part (c) Write your observations of what the data in the two-way table means and why this is important analysis information. Inputs Yearly rental cost Other monthly fixed costs Cost per copy Charge per copy Days per year Months per year Copies per copier per year Profit model Copiers rented (trial value) Daily demand (trial value) Copies made Annual profit $5,000 $400 $0.03 $0.10 365 12 100,000 3 1000 300,000 $1,200 Part (a) Use two-way data table (copies rented along the top, daily demand along the side) Use conditional formatting to highlight negative numbers and positive numbers in the table. 1 1,200 3 5 500 1000 1500 2000 -2800 -2800 -2800 -2800 Part (b) Create a Break-even example. Copiers Rented Daily Demand Copies Made Annual Profit 3 0 2 -2025 -800 -800 -800 -7025 1200 1200 1200 -12025 750 3200 3200 -17025 -4250 5200 5200 Part (c) Write your observations of what the data in the two-way table means and why this is important analysis information.
Expert Answer:
Answer rating: 100% (QA)
Part a TwoWay Data Table with Conditional Formatting Table Copies Rented Daily Demand 500 1000 1500 2000 1 Annual Profit 2800 2800 2800 2800 2 Annual ... View the full answer
Related Book For
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright
Posted Date:
Students also viewed these finance questions
-
Sitxfin010 - Prepare and monitor budgets - Power Point Presentation You need to develop a power point presentation in order to convince your department heads to allocate you money to buy your...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
How are Bit coins different from VCU1, VCU2, and VCU3 currencies? How are they similar? What is the primary economic threat of Bit coins?
-
Charles and Joan Thompson file a joint return. In 2014, they had taxable income of $92,370 and paid tax of $14,806. Charles is an advertising executive and Joan is a college professor. During the...
-
Find the limit as x approaches c of the average rate of change of the function from c to x. c = -2; f(x) = 4 - 3x
-
X Ltd entered into a lease agreement on the following terms: Required: Show the income statement entries for the years ended 31 December 20X4 and 20X7 and balance sheet extracts at those dates. Cost...
-
Euclid Fashions, Inc., is introducing a sports jacket. A standard cost card has been prepared for the new jacket, as shown below: The following additional information relating to the new jacket is...
-
Consider the following. y=7x- In(x), (1, 7) Find an equation of the tangent line to the graph of the function at the given point. Use a graphing utility to graph function and its tangent line at the...
-
Forecasting with the Parsimonious Method and Estimating Share Value Using the ROPI Model Following are income statements and balance sheets for Cisco Systems. Cisco Systems Consolidated Statements of...
-
Daba Company manufactures two products, Product F and Product G. The company expects to produce and sell 2,000 units of Product F and 2,400 units of Product G during the current year. The company...
-
Given C(x)=10x+3 and R(x) = 50x-0.5x2 Find each of the following a) Total Profit, P(x), b) Total Cost, C (x). Revenue R(x) and Profit P(x) from the production and sale of 40 units c) The Marginal...
-
A boat is stationary at 12 meters away from a dock. The boat then begins to move toward the dock with an acceleration of 5.0 m $2 How long will it take the boat to reach the dock? Your answer should...
-
Concord Company is a leading manufacturer of sunglasses. One of Concord's products protects the eyes from ultraviolet rays. An upscale sporting goods store has contacted Concord about purchasing...
-
Describe the normalization forms and why different normalization forms exist. Should normalization be done on all databases? To what form should databases be normalized?
-
Ivanhoe Corporation issued convertible bonds at a premium of $10400. The $200000 bond issue was convertible into 4400 shares of common stock (par value $20). Two years later, all of the bonds were...
-
Write an Abstract and Literature Review for a research paper based on this articles References from 1-10. 1.Amick HR;Gartlehner G;Gaynes BN;Forneris C;Asher GN;Morgan LC;Coker-Schwimmer E;Boland...
-
When an electric field is applied to a shallow bath of vegetable oil, why do tiny bits of thread floating in the oil align with the field like compasses in a magnetic field?
-
The effect of the shapes of input distributions on the distribution of an output can depend on the output function. For this problem, assume there are 10 input variables. The goal is to compare the...
-
In the VanBuren machine replacement problem, the companys current policy is to keep a machine at least 4 quarters but no more than 12 quarters. Suppose this policy is instead to keep a machine at...
-
For each of the following, answer whether it makes sense to multiply the matrices of the given sizes. In each case where it makes sense, demonstrate an example in Excel, where you make up the...
-
The emergency room at University Hospital uses a flexible budget based on patients seen as a measure of volume. An adequate staff of attending and on-call physicians must be maintained at all times,...
-
The new printing department of Shark Advertising Inc. provides printing services to the other departments. Prior to the establishment of the in-house printing department, the departments contracted...
-
Shakie Sports Company made 20,000 leather basketballs in a given year. Its total manufacturing costs were $170,000 variable and $70,000 fixed. Assume that no price changes will occur in the following...
Study smarter with the SolutionInn App