I am stuck on questions 5,7,8 if you could help me that would greatly appreciated.

1. In the Fineprint Excel Template provided (Exhibit 1tab), complete the highlighted cells in column B to represent cost per unit (where one unit is 100 brochures). All calculations must be done directly in the template using Excel formulas (MANUALLY ENTERED AMOUNTS WILL RECEIVE ZERO CREDIT).

2. Explain the difference between manufacturing costs and nonmanufacturing costs and provide examples for each.

3. Explain the difference between fixed cost behavior and variable cost behavior in terms of volume, total cost, and unit cost. Provide examples of fixed costs and variable costs.

4. What factors should John Johnson consider when deciding whether or not to accept Abbie Jenkin's order? Are all of the factors quantitative? Explain your responses.

5. Considering the information provided in the case, should John Johnson accept Abbie Jenkin's order? Support your decision with quantitative analysis (in Excel) and solid rationale.

6. Assume that current monthly production at Fineprint is 120,000 brochures. Use the unit cost information you computed in item 1 (above) to prepare a cost analysis for the new level of production. You may create (and label) a new sheet in the Excel file or add to the Exhibit 1 sheet provided. Regardless of your approach, do not type amounts into the cells; use formulas and feed data from cells, as appropriate.

7. Should Mr. Johnson accept Ms. Jenkins order under these circumstances? Support your decision with quantitative analysis (in Excel) and solid rationale.

8. How should FinePrint respond to the opportunity presented by SmallPrint Shop? Answer the question in your own words and support your decision with quantitative analysis and solid rationale.

9. Explain what is meant by opportunity cost. Did opportunity cost play a role in any of your decisions?

10. Explain, in your own words what you have learned about cost behavior from completing this case.

FINEPRINT COMPANY who wenty ved in the past couple of a fa small company in any, FinePrint Compar . Ernest Bradley, the esville, Virginia, call John Johnson reflected on both offers he had received First. Abbie Jenkins, a friend of Johnson's and the owner of a sm Keswick. Virginia, had called to see if Johnson's printing company could accommodate a special printing order next month. In ada owner of a local one-room printing operation in Charlottes SmallPrint Shop, had stopped by to see if FinePrint Company printing color brochures over the next few months. company could use some b e some very THE OU COMPANY BACKGROUND Johnson's company, FinePrint Company, printed elaborate high- brochures in its facility located in Charlottesville, Virginia. It primarily businesses in the central Virginia area, although it did have some clients in Virginia and as far east as the Chesapeake Bay region of the state. Monthly its Charlottesville facility was running at around full capacity of 150.000 bree month. John Johnson owned and managed the company. He employed representative and one printing press operator, although he frequently relied on tem labor to help in the printing process as needed to accommodate any changes in prin volume. John felt that many of his costs were fixed, but that some costs varied with number of brochures he printed and sold. Exhibit 1 contains information related FinePrint's monthly operating costs for the company's current activity level of 150.000 high-quality color rimarily served other ients in southwest thly production at 00 brochures per ploved one sales lied on temporary sin printing brochures per month The company typically priced its printing services at an average of $17 per 100 brochures printed. Historically, Johnson had encountered little variation in pricing from job to job, although occasionally, special situations did arise. He wondered how he should handle those special situations. He didn't have a "rule of thumb" he could apply. but he wished he could find one. THE SPECIAL ORDER In her phone call, Abbie Jenkins indicated that she needed a special job printed next month. She needed 25,000 brochures related to a new product for distribution at three trade shows she was attending. When John quoted Abbie the usual price of $17 per 100 brochures, Abbie sighed. John, I know that FinePrint does a high-quality job, but I'm short on funds right now because I have spent so much on getting this new product up and running. I can't go any higher than $10 per 100 brochures on this job. If you can't do it for that, I'll have to go to someone else. I'm sure the brochures won't look as nice, but that's all I've got to spend." PARTI: UNDERSTANDING COSTE DUT John was enthused about the potential business, but when he inquired about whether Abbie would have future printing needs that FinePrint could help with, Abbie expressed doubt. "We just don't do much of this type of stuff. This is the first material we've had printed like this in years, and we're only doing it because we're trying to get this new product off the ground. I suspect this will be the last for a long while. John knew he didn't have the capacity at the moment to handle the special order. And, SIU per 100 brochures sounded low John replied. Let me look into this man sure we can do it for $10. but I'll be glad to think about it. I'll give you a call back in a couple of days." John realized that with this order he wouldn't have to pay his sales representative the typical sales commission of $1 per 100 brochures, but that $l savings wouldn't begin to make up for the lower price. THE OUTSOURCING OPPORTUNITY Ernest Bradley owned a local one-room printing operation called SmallPrint Shop. His largest customer had just informed him that it was going out of business and would no longer need his printing services. Most of Small Print's customers were small companies needing basic printing services in small quantities. But several of his customers, including his largest customer, used his services for both basic printing services and more elaborate work, including color brochures. Ernest had a long-standing relationship with the customer's owner and had purchased the small printing press he used for color brochures partially to serve this customer's needs. He wasn't sure how he was going to get enough business to make up for this loss, especially since he primarily was known for his basic printing services rather than printing elaborate brochures. Ernest decided to stop by to talk with John Johnson, owner of FinePrint Company. I've had some bad luck. My largest customer just informed me that it is closing its doors. I've been doing their color printing work for several years, and their closing leaves me with a lot of idle capacity. I wonder if you have any extra brochure printing I can help with. I'd be happy to do it really cheaply, just to keep my press going. I would go as low as $8 per 100 brochures. And I could handle 30,000 brochures for you next month." John thought that $8 per 100 brochures sounded like a good deal. He wasn't sure that even he could print that cheaply. And he knew that SmallPrint did a good job. He had used them before. They did high-quality work, and were dependable. FINEPRINT COMPANY who wenty ved in the past couple of a fa small company in any, FinePrint Compar . Ernest Bradley, the esville, Virginia, call John Johnson reflected on both offers he had received First. Abbie Jenkins, a friend of Johnson's and the owner of a sm Keswick. Virginia, had called to see if Johnson's printing company could accommodate a special printing order next month. In ada owner of a local one-room printing operation in Charlottes SmallPrint Shop, had stopped by to see if FinePrint Company printing color brochures over the next few months. company could use some b e some very THE OU COMPANY BACKGROUND Johnson's company, FinePrint Company, printed elaborate high- brochures in its facility located in Charlottesville, Virginia. It primarily businesses in the central Virginia area, although it did have some clients in Virginia and as far east as the Chesapeake Bay region of the state. Monthly its Charlottesville facility was running at around full capacity of 150.000 bree month. John Johnson owned and managed the company. He employed representative and one printing press operator, although he frequently relied on tem labor to help in the printing process as needed to accommodate any changes in prin volume. John felt that many of his costs were fixed, but that some costs varied with number of brochures he printed and sold. Exhibit 1 contains information related FinePrint's monthly operating costs for the company's current activity level of 150.000 high-quality color rimarily served other ients in southwest thly production at 00 brochures per ploved one sales lied on temporary sin printing brochures per month The company typically priced its printing services at an average of $17 per 100 brochures printed. Historically, Johnson had encountered little variation in pricing from job to job, although occasionally, special situations did arise. He wondered how he should handle those special situations. He didn't have a "rule of thumb" he could apply. but he wished he could find one. THE SPECIAL ORDER In her phone call, Abbie Jenkins indicated that she needed a special job printed next month. She needed 25,000 brochures related to a new product for distribution at three trade shows she was attending. When John quoted Abbie the usual price of $17 per 100 brochures, Abbie sighed. John, I know that FinePrint does a high-quality job, but I'm short on funds right now because I have spent so much on getting this new product up and running. I can't go any higher than $10 per 100 brochures on this job. If you can't do it for that, I'll have to go to someone else. I'm sure the brochures won't look as nice, but that's all I've got to spend." PARTI: UNDERSTANDING COSTE DUT John was enthused about the potential business, but when he inquired about whether Abbie would have future printing needs that FinePrint could help with, Abbie expressed doubt. "We just don't do much of this type of stuff. This is the first material we've had printed like this in years, and we're only doing it because we're trying to get this new product off the ground. I suspect this will be the last for a long while. John knew he didn't have the capacity at the moment to handle the special order. And, SIU per 100 brochures sounded low John replied. Let me look into this man sure we can do it for $10. but I'll be glad to think about it. I'll give you a call back in a couple of days." John realized that with this order he wouldn't have to pay his sales representative the typical sales commission of $1 per 100 brochures, but that $l savings wouldn't begin to make up for the lower price. THE OUTSOURCING OPPORTUNITY Ernest Bradley owned a local one-room printing operation called SmallPrint Shop. His largest customer had just informed him that it was going out of business and would no longer need his printing services. Most of Small Print's customers were small companies needing basic printing services in small quantities. But several of his customers, including his largest customer, used his services for both basic printing services and more elaborate work, including color brochures. Ernest had a long-standing relationship with the customer's owner and had purchased the small printing press he used for color brochures partially to serve this customer's needs. He wasn't sure how he was going to get enough business to make up for this loss, especially since he primarily was known for his basic printing services rather than printing elaborate brochures. Ernest decided to stop by to talk with John Johnson, owner of FinePrint Company. I've had some bad luck. My largest customer just informed me that it is closing its doors. I've been doing their color printing work for several years, and their closing leaves me with a lot of idle capacity. I wonder if you have any extra brochure printing I can help with. I'd be happy to do it really cheaply, just to keep my press going. I would go as low as $8 per 100 brochures. And I could handle 30,000 brochures for you next month." John thought that $8 per 100 brochures sounded like a good deal. He wasn't sure that even he could print that cheaply. And he knew that SmallPrint did a good job. He had used them before. They did high-quality work, and were dependable