Question

In: Accounting

Streeterville Foods, Inc., has recently purchased a small mill that it intends to operate as one...

Streeterville Foods, Inc., has recently purchased a small mill that it intends to operate as one of its subsidiaries. The newly acquired mill has three products that it offers for sale—wheat cereal, pancake mix, and flour. Each product sells for $10 per package. Materials, labor, and other variable production costs are $4.90 per bag of wheat cereal, $6.10 per bag of pancake mix, and $3.10 per bag of flour. Sales commissions are 10% of sales for any product. All other costs are fixed

The mill’s income statement for the most recent month is given below:

Total Company

Wheat Cearal

Pancake Mix

Flour

Sales

        1,170,000.00

        390,000.00

       490,000.00

   290,000.00

Expenses

Materials, labor, other

            579,900.00

        191,100.00

       298,900.00

     89,900.00

Sales Commissions

            117,000.00

          39,000.00

         49,000.00

    29,000.00

Advertising

            156,050.00

          73,000.00

         50,000.00

     33,050.00

Salaries

              98,500.00

          43,300.00

         10,200.00

     45,000.00

Equipment Depreciation

              58,500.00

         19,500.00

         24,500.00

     14,500.00

Warehouse rent

              23,400.00

             7,800.00

           9,800.00

       5,800.00

General Administration

              84,000.00

          28,000.00

         28,000.00

     28,000.00

Total Expenses

        1,117,350.00

        401,700.00

       470,400.00

   245,250.00

Net Operating income (loss)

              52,650.00

        (11,700.00)

         19,600.00

     44,750.00

The following additional information is available about the company:

a.

The same equipment is used to mill and package all three products. In the above income statement, equipment depreciation has been allocated on the basis of sales dollars. An analysis of equipment usage indicates that it is used 40% of the time to make wheat cereal, 50% of the time to make pancake mix, and 10% of the time to make flour..

b.

All three products are stored in the same warehouse. In the above income statement, the warehouse rent has been allocated on the basis of sales dollars. The warehouse contains 46,800 square feet of space, of which 8,000 square feet are used for wheat cereal, 14,000 square feet are used for pancake mix, and 24,800 square feet are used for flour. The warehouse space costs the company $0.50 per square foot per month to rent.

c.

The general administration costs relate to the administration of the company as a whole. In the above income statement, these costs have been divided equally among the three product lines.

d.

All other costs are traceable to the product lines.

Streeterville Foods’ management is anxious to improve the mill’s 4.5% margin on sales.

Required:

1.

Prepare a new contribution format segmented income statement for the month. Adjust the allocation of equipment depreciation and warehouse rent as indicated by the additional information provided.

Solutions

Expert Solution


Related Solutions

If a small monster collector: • Has 16 small monster containment devices and intends to use...
If a small monster collector: • Has 16 small monster containment devices and intends to use all of them • Has access to Earth-type, Air-type and Cloud-type small monsters that we do not consider unique • Intends to capture at least two of each type • Intends to capture at most four Cloud-types How many different combinations of small monster types can the collector capture?
A steel company has two mills. Mill 1 costs $70,000 per day to operate, and it...
A steel company has two mills. Mill 1 costs $70,000 per day to operate, and it can produce 400 tons of high-grade steel,500 tons of medium-grade steel, and 450 tons of low-grade steel each day. Mill 2 costs $60,000 per day to operate, and it can produce 350 tons of high-grade steel, 600 tons of medium-grade steel, and 400 tons of low-grade steel each day. The company has orders totaling 100,000 tons of high-grade steel, 150,000 tons of medium-grade steel,...
A steel company has two mills. Mill 1 costs $70,000 per day to operate, and it...
A steel company has two mills. Mill 1 costs $70,000 per day to operate, and it can produce 400 tons of high-grade steel,500 tons of medium-grade steel, and 450 tons of low-grade steel each day. Mill 2 costs $60,000 per day to operate, and it can produce 350 tons of high-grade steel, 600 tons of medium-grade steel, and 400 tons of low-grade steel each day. The company has orders totaling 100,000 tons of high-grade steel, 150,000 tons of medium-grade steel,...
Suppose you operate a small manufacturing firm in Long Island City and you recently developed a...
Suppose you operate a small manufacturing firm in Long Island City and you recently developed a unique, new production process that will allow your shop to earn $500 more per month in profit. Your landlord hears about this and smiles since she remembers from her urban economics class that all economic development benefits accrue to landowners. She says, “Since the supply of land is inelastic, you will now have to pay me $500 more per month in rent.” Is your...
A Corporation has recently acquired a small manufacturing operation in British Columbia that produces one of...
A Corporation has recently acquired a small manufacturing operation in British Columbia that produces one of its more popular items. This plant will provide these units for resale in retail hardware stores in British Columbia and Alberta. Because the budget prepared by the plant was incomplete, Jordan Leigh, Waterways’ CFO, was sent to B.C. to oversee the plant’s budgeting process for the second quarter of 2017. Jordan asked the various managers to collect the following information for preparing the second-quarter...
A Corporation has recently acquired a small manufacturing operation in British Columbia that produces one of...
A Corporation has recently acquired a small manufacturing operation in British Columbia that produces one of its more popular items. This plant will provide these units for resale in retail hardware stores in British Columbia and Alberta. Because the budget prepared by the plant was incomplete, Jordan Leigh, Waterways’ CFO, was sent to B.C. to oversee the plant’s budgeting process for the second quarter of 2017. Jordan asked the various managers to collect the following information for preparing the second-quarter...
Question1 You are working for a food retailer named Half-Foods. Half-Foods has been recently acquired by...
Question1 You are working for a food retailer named Half-Foods. Half-Foods has been recently acquired by a large company, and the new management wants to review store sales and staffing in search for improvement opportunities. Half-Foods has 93 stores across the US. From the analysis of historical data, you believe that annual store sales follows a Normal distribution with a mean of $70.1973 M, and standard deviation of $9.13183 M. Also, the number of store employees follows a continuous uniform...
A European call option written on one share of Ponce de Leon Foods, Inc. has the...
A European call option written on one share of Ponce de Leon Foods, Inc. has the following parameter values: S = $116, X = $101, r = 7% p.a.,  = 27% p.a., T = 6 months. Find the value of d1, rounded to 4 decimals (e.g., 0.0712). NOTE: Use the continuous time version of the equation
A European call option written on one share of Ponce de Leon Foods, Inc. has the...
A European call option written on one share of Ponce de Leon Foods, Inc. has the following parameter values: S = $118, X = $108, r = 5% p.a., sigma = 21% p.a., T = 7 months. Find the value of d1, rounded to 4 decimals (e.g., 0.0712). QUESTION 2 A European call option written on one share of Crook & Crook, Inc. has the following parameter values: S = $34, X = $36, r = 5% p.a., sigma =...
Waterways Corporation has recently acquired a small manufacturing operation in British Columbia that produces one of...
Waterways Corporation has recently acquired a small manufacturing operation in British Columbia that produces one of its more popular items. This plant will provide these units for resale in retail hardware stores in British Columbia and Alberta. Because the budget prepared by the plant was incomplete, Jordan Leigh, Waterways' CFO, was sent to B.C. to oversee the plant's budgeting process for the second quarter of 2021. Jordan asked the various managers to collect the following information for preparing the second-quarter...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT