Question

In: Accounting

Read the following case, and fill out the table below based on the case: Horizon Insurance...

Read the following case, and fill out the table below based on the case:

Horizon Insurance (HI) was a full-service regional insurance agency that has done all the printing and publishing of its own promotional brochures, newsletters, informational pamphlets, and required regulatory reports. Linda Wolfe, the business manager of the agency, had for some time thought that the firm might save money and get equally good services by contracting the publishing work G-Art Inc. She asked G-Art Inc. to give her a quote at the same time she asked Bob Myer her controller to prepare an up-to-date statement of the cost of operating Horizon’s publishing department.

Within a few days, the quote from G-Art Inc. arrived. The firm was prepared to provide all the required publications work for $ 410,000 a year with the contract running a guaranteed term of 4 years with annual renewals thereafter. If the estimated number or assumed mix of publications changed in any given year beyond the baseline planning estimates, the contract price would be adjusted accordingly. Wolfe compared G-Art’s quote with the internal cost figures prepared by Myer:

Table 1; Annual cost of operating HI’s publications department: Myer’s figures.

Materials                                                                                                             $40,000

Labor                                                                                                                 $290,000

Department overhead

Manager’s salary                                                                                            $48,000                                  

Allocated cost of office space                                  $10,000

Depreciation of equipment                                       $32,500

Other expenses (travel, education, ect.)               $25,000

                                                                                                                             $115,500

                                                                                                                            $445,500

Share of company administrative overhead                                         $30,000

Total cost of department for year                                                          $475,000

Wolfe’s initial conclusion was to close Horizon’s publications department and immediately sign the contact offered by G-Art. However, she felt it prudent to give the manager of the department, George Richards, an opportunity to question that tentative conclusion. She called him in and put the facts before him, while at the same time making it clear that Richards’ own job at the agency was not in jeopardy.

Richard came up with the following to keep in mind before his department was closed:

For instance, what will you do with the customed graphic design and printing equipment? It cost $260,000 four years ago, but you’d be lucky if you got $80,000 for it now, even though we had planned on using it for another four years at least. Andthen there is the sizable supply of print materials that includes a lot of specialized ink, specialty card stock, paper, envelopes ect. We bought the custom supplies a year ago when we were pretty flush with cash. At that time it cost us about 125,000 and at the rate we are using it now, it will last us another four years. We used up about one-fifth of it last year. As best as I an tell, Myer’s figure of $40,000 for materials includes about $25,000 for these customized sipplies and $15,000 for generic supplies we use on a regular basis. If we were to buy these custom supplies today it would probably cost us 110% of what we paid for it. But if we try to sell it, we would probably get only 60% of what we paid for it.

Wolf thought that Myer ought to be present during this discussion. She called him in and put Richard’s points to him. Myer said:

If we are going to have all of this talk about “what will happen if” don’t forget the problem of space we’re faced with. We’re paying 12,000 a year in outside office space. If we close Richard’s department we could use of the freed-up space as office space and not need to rent it on the outside.

Wolfe replied:

That’s a good point, though I must say I’m a bit worried about the people if we close the publications department. I don’t think we can find room for any of them elsewhere in the firm. I could see whether G-rt can take any of them, but some of them are getting odler. There’s Walters and Hines, for example. They’ve been with us since they left school 40 years ago, and I think their contract requires us to give them a total severance payoff of about $60,000 each, payable in equal amounts over four years.

Richards showed some relief at this. “ But I still don’t like Myer’s figures” he said. “What about the $30,000 for general administrative overhead. You surely don’t expect to fire anyone in the corporate office if Im closed, do you?

“Probably not” said Myer, but someone has to pay for those costs. We can’t ignore them when we look at an individual department, because fi we do that with each department in turn, we will convince ourselves that accountants, laywers, vice presidents, and the like don’t’ have to be paid for. And they do, believe me”

Myer’s figures

Total cost inside

Total cost with G-Art Contract

Savings (higher cost) contracting outside

Material: Generic supplies

$15,000

                  Custom supplies

$25,000

Labor:       Wages

$290,000

                  Severance

Overhead: Manger’s Salary

$48,000

                    Office (internal)

$10,000

                    Office rental

                 Equipment deprec.

$32,500

                  Other

$25,000

Share of general and administrative

$30,000

Total

475,000

G-Art Contract

410,000

Net Difference

65,500

Clarification: In the fact set, Custom Supplies are expected to sell for 60% of what the company paid for them. Assume (to make numbers cleaner), that this is 60% of their 'current' book value of $100,000 (derived from the fact set), not the original cost.

Question: Fill out the table above and determine the question below:

What is the annual difference in expense (accounting cost) if Horizon Insurance outsources to G-Art? Do not consider the gain or loss from the sale of special materials or equipment in this calculation. It might be helpful to use the worksheet provided in the case.

Solutions

Expert Solution


Related Solutions

Fill in all the remaining blanks in the table below and fill out the appropriate formula each.
Fill in all the remaining blanks in the table below and fill out the appropriate formula each.Residual maturityResidual MaturityInterest rate of Zero coupon bondPrice of Zero Coupon Bondone-year intrinsic forward interest ratepar yield18.00%27.00%36.00%
ONLY FILL OUT THE TABLE AND ANSWER THE QUESTION BELOW THE TABLE First workout design –...
ONLY FILL OUT THE TABLE AND ANSWER THE QUESTION BELOW THE TABLE First workout design – Fibromyalgia (5 points) You have a client that has been diagnosed and has been managing fibromyalgia for 10 years, aged 45 and female. She has multiple hypersensitive areas in her shoulders, hips, and feet. She lives a somewhat active life, walking her dog and doing household chores. Her goals in working with you are to improve her energy level, decrease her daily pain, and...
ONLY FILL OUT THE TABLE AND ANSWER THE QUESTION BELOW THE TABLE Third workout design –...
ONLY FILL OUT THE TABLE AND ANSWER THE QUESTION BELOW THE TABLE Third workout design – Low Back Pain (5 points) Your client is a 52 year-old woman that injured her lower back at work 5 years ago, and has been managing low back pain on and off ever since. She now takes anti-inflammatory medication regularly, but not every day. She has tightness and pain in her back with prolonged sitting or standing. She is moderately overweight, has not exercised...
ONLY FILL OUT THE TABLE AND ANSWER THE QUESTION BELOW THE TABLE Second workout design –...
ONLY FILL OUT THE TABLE AND ANSWER THE QUESTION BELOW THE TABLE Second workout design – Prepubescent Child (5 points) You have an existing client that now wants you to train their 11 year-old, son. The child is active, but does not like sports and is slightly overweight. His (and his parents) goals in working with you are to learn how to exercise safely and effectively in the club that his parents belong to, find exercises that he likes and...
ONLY FILL OUT THE TABLE AND ANSWER THE QUESTION BELOW THE TABLE Fourth workout design –...
ONLY FILL OUT THE TABLE AND ANSWER THE QUESTION BELOW THE TABLE Fourth workout design – Knee Ligament Instability (5 points) Your client is a 29 year-old man that tore his ACL, MCL, and medial meniscus 12 months prior while skiing. He had surgery to repair all three structures 10 months ago, and has completed 3 months of physical therapy. His goals are to continue to strengthen his hamstring muscles (physical therapy), reduce the occasional swelling and pain he has...
**DO NOT FILL OUT THE QUESTIONAIRE, IT IS NOT ASKING TO FILL IT OUT** Below is...
**DO NOT FILL OUT THE QUESTIONAIRE, IT IS NOT ASKING TO FILL IT OUT** Below is the second page of a survey questionnaire. " Spot four poorly designed features in such page " : ... ... ... ... ... ... ... ... 2. State your age in years _ _ 3. How long have you used the Internet? (check one only) _ < 1 year _ 1 - 4 years _ 4 - 8 years _ > 8 years 4....
Fill in the table below, using the information on this handout, based on what is best...
Fill in the table below, using the information on this handout, based on what is best for the client. Jake (age 47) and Sally (age 37) are married and have three children, ages 4, 7, and 10. The W2 table is for the 2019 income tax year. Assume tax laws in 2019 are as described in the textbook. They will file as Married Filing a Joint Return. If no information is given about something, assume zero, e.g., zero contributions to...
(Experiment) Measure all the dimension of the four objects and fill out the table below. As...
(Experiment) Measure all the dimension of the four objects and fill out the table below. As the ‘proof’ that you did the experiments, take a screenshot of your PC screen for at least one dimension of each and insert (copy and paste) the screenshots to the end of this data sheet. (For Window’s users, ‘snipping tool’ is convenient to take a screenshot. You can search the tool by searching ‘snipping tool’ on Windows Search. For Mac users, press ‘Command’ +...
You must fill out the table below, then you must find the values for a, b1...
You must fill out the table below, then you must find the values for a, b1 and b2, finally you must determine how much the profits would be if you invest 10 thousand dollars in advertising and if you increase it to 20 sellers. REMEMBER all the procedures and formulas should appear. Y X1 X2      1 2 3 4 5 Year Sales $ promotion Sales person åX1 Y X12 X1 X2 X2Y X22 2017 18 2 2 2018 23...
  Fill out the table below. Be sure to use a different font color (red or blue...
  Fill out the table below. Be sure to use a different font color (red or blue are great). Include the following types of microbes: Algae, Archaea, Bacteria, Fungi, Helminths, Protists, and Viruses. Type of Microbe Domain Eukarya Cell type prokayotic acellular eukaryotic Organization unicellular Multicellular (except yeast) multicellular Cell Wall (y/n) Type of material cell wall w/o peptidoglycan No Nutrition Intracellular parasites heterotrophic Autotrophic Example(s) E. coli Flatworms Roundworms
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT