Reference no: EM13509503
Vega 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.30 per bag of wheat cereal, $5.50 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:
|
|
|
|
|
Product Line
|
|
|
Total
Company
|
Wheat
Cereal
|
Pancake
Mix
|
Flour
|
|
|
Sales
|
$
|
990,000
|
|
$
|
330,000
|
|
$
|
430,000
|
|
$
|
230,000
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Expenses:
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Materials, labor, and other
|
|
449,700
|
|
|
141,900
|
|
|
236,500
|
|
|
71,300
|
|
|
|
Sales commissions
|
|
99,000
|
|
|
33,000
|
|
|
43,000
|
|
|
23,000
|
|
|
|
Advertising
|
|
139,380
|
|
|
60,900
|
|
|
52,200
|
|
|
26,280
|
|
|
|
Salaries
|
|
105,000
|
|
|
51,000
|
|
|
21,000
|
|
|
33,000
|
|
|
|
Equipment depreciation
|
|
49,500
|
|
|
16,500
|
|
|
21,500
|
|
|
11,500
|
|
|
|
Warehouse rent
|
|
19,800
|
|
|
6,600
|
|
|
8,600
|
|
|
4,600
|
|
|
|
General administration
|
|
90,000
|
|
|
30,000
|
|
|
30,000
|
|
|
30,000
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total expenses
|
|
952,380
|
|
|
339,900
|
|
|
412,800
|
|
|
199,680
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net operating income (loss)
|
$
|
37,620
|
|
$
|
(9,900)
|
|
$
|
17,200
|
|
$
|
30,320
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 39,600 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 17,600 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.
Vega Foods' management is anxious to improve the mill's 3.80% 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.
|
What is the time required to read a ?le containing 100000
: What is the time required to read a ?le containing 100,000 records of 100 bytes each in a random order? To read a record, the block containing the record has to be fetched from disk. Assume that each block request incurs the average seek time and rot..
|
|
How many cylinders does the disk have
: Consider a disk with a sector size of 512 bytes, 2000 tracks per surface, 50 sectors per track, ?ve double-sided platters, and average seek time of 10 msec.
|
|
Give an example of an update that is definitely slowed
: The title of the ?rst record in the previous set, and the primary key of the ?rst record in the previous set.
|
|
Search for a record based on a particular field value
: For each of the following queries, which of the listed index choices would you choose to speed up the query? If your database system does not consider index-only plans (i.e., data records are always retrieved even if enough information is available i..
|
|
Prepare a new contribution format segmented income statement
: 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.
|
|
Obtain the magnitude of the force
: Two blocks, each with weightw, are held in place on a frictionless incline in terms ofwand the angleaof the incline. Calculate the magnitude of the force that the incline exerts on each block in N
|
|
Vivians medical expenses paid by the johnsons
: Can you report on Schedule A Vivian's medical expenses paid by the Johnsons - Are expenses to prepare you for a new trade or business deductible?
|
|
Clustered versus unclustered indexes
: Choice of search key for the index. What is a composite search key, and what considerations are made in choosing composite search keys? What are index-only plans, and what is the in?uence of potential index-only evaluation plans on the choice of sear..
|
|
How much time does it take to reach this height
: A model rocket rises with a constant acceleration to a height of 3.2m, at which point its speed is 26m/s. How much time does it take to reach this height
|