Reference no: EM131200194
1. Angela and Bob Master have decided to start a company, Copymax, that will place self-service copy machines onto customer premises in libraries, universities, high schools, shopping malls, etc. They plan to keep capital costs to a minimum by leasing heavy-duty copiers that have a self-service coin and smart card reader device attached. In addition to the lease cost and other expenses of the copier, Copymax would pay a fee to the customer organization providing the space for the copier. This fee would consist of a fixed monthly space rent plus, optionally, some incentive payments. As part of their business plan,
Angela and Bob have made the following assumptions:
Number of Copiers Leased 40
Copies per Month per Copier variable (Assume Demand = Production)
Price Charged per Copy $.05
Variable Cost per Copy $.03
Monthly Copier Space Rental Rate (per copier) $150
Other Monthly Expenses:
Lease Cost of Each Copier $250
Coin Collection Labor per Copier $35
Miscellaneous Fixed costs per Copier $50
Call the original plan, option A. The Masters are considering two other alternative arrangements for copier space rental payments.
In Option B, Masters would pay a space rent of only $50 per month per copier but would add a commission of one-half cent per copy. (They would be paying that on top of the fixed rent)
In Option C, CopyMax would pay a space rent of $75 per month per copier. A commission of one cent per copy would be paid only for that portion of the monthly volume (copies/month/copier) that exceeds a predetermined cutoff of 20,000 copies. (IF function will be required here)
a. Develop (three separate) spreadsheet models that can be used to determine the profit for each of the three options given the unknown variable of copy Demand.
b. Determine the break-even number of COPIES PER MONTH for each option
c. Create a (single) graph that will show how Profit for the three options responds to changes in Volume(copies per month per copier.)
d. At what Volume would the original option have the same Cost as the second option (read approximately off your graph)?
1.Set up complete models to calculate profit for each option
2.Make Excel do all of the work, all calculations.
3.Use the Excel Goal Seek, IF where applicable.
4.Report results and answers to questions
|
Why does the eitc exacerbate the marriage penalty
: Why does the EITC exacerbate the marriage penalty for low-income workers?- Suggest an alternative method of calculating the EITC that reduces this penalty.
|
|
Calculate individuals federal marginal tax rate
: Use the model to calculate these individuals' federal (effective) marginal tax rates and federal income tax liability in 1988, 1998, and 2008. - Explain the pattern that you find.
|
|
Real estate developer is planning to build an office complex
: A real estate developer is planning to build an office complex. Currently, there are three office sizes under consideration: small, medium, and large. Small offices can be rented for $600 per month, medium offices can be rented for $750 per month, an..
|
|
What is the monopolist''s markup over the competitive price
: What is the monopolist's markup over the competitive price? Does the result of your answer change if the game is played an infinite number of times? Why or why not? Properly use game theoretic terminology in your answer.
|
|
Determine break-even number of copies per month for option
: Angela and Bob Master have decided to start a company, Copymax, that will place self-service copy machines onto customer premises in libraries, universities, high schools, shopping malls, etc. Determine the break-even number of COPIES PER MONTH for e..
|
|
Question on internet service provider
: An Internet service provider has three different subscription packages for its customers: Package A: $9.95 per month for 10 hours access. Additional hours are $2.00 per hour Package B: $13.95 per month for 20 hours access. Additional hours are $1.00 ..
|
|
What is marginal tax rate and average tax rate
: What is your marginal tax rate? What is your average tax rate? Do these rates differ? Why or why not?- What is the likely effect on the labor supply of married women?
|
|
Elements of a data center besides the core elements
: Research other elements of a data center besides the core elements discussed in this chapter, including environmental control parameters such as HVAC (heat, ventilation, and air-condition), power supplies, and security.
|
|
Represent a data item in ieee 64-bit floating point format
: Why may a programmer choose to represent a data item in IEEE 64-bit floating point format instead of IEEE 32-bit floating point format? What additional costs may be incurred at run time (when the application program executes) as a result of using ..
|