Question
Selected Financial Data (actual cost and revenue data for May 2020) Cost Category Behavior May 2020 Sales $766,667 Expenses: Raw Materials Variable $327,934 Bakery labor
Selected Financial Data(actual cost and revenue data for May 2020)
Cost Category | Behavior | May 2020 |
Sales | $766,667 | |
Expenses: Raw Materials | Variable | $327,934 |
Bakery labor | Mixed | $158,767 |
Administration Salaries | Fixed | $41,367 |
Supplies | Variable | $3,833 |
Freight & Shipping-In | Variable | $4,907 |
Freight & Shipping-Out | Variable | $64,707 |
Utilities - Electricity | Variable | $9,813 |
Utilities - Gas (ovens) | Variable | $3,067 |
Water | Variable | $920 |
Repairs & Maintenance | Fixed | $4,293 |
Rent expense | Fixed | $19,167 |
Telephone & Internet | Fixed | $2,300 |
Co-owners' salary | Fixed | $25,300 |
Brokers' commissions | Variable | $30,667 |
Total Expenses | $697,042 | |
Operating Profit | $69,625 | |
Income Tax | $22,280 | |
Net operating income | $47,345
| |
Unit volume | 64,500 | |
Average Operating Assets | $5,500,000 | |
Minimum Rate of Return | 8.00% |
Notes to Selected Financial Data
Raw Materials: Includes main ingredients and flavor additives. Main ingredients are relatively higher cost items such as flour, sugar, eggs, nuts and fruit that appear on the package label. Flavor additives are relatively low-dollar cost items and a small part of the weight of the pie such as spices, dyes, salt, and certain oils that don't always appear on the package label.
Bakery labor: The cost amount consists of 22% supervisory salaries and taxes and the rest hourly workers. Bakery labor workers are organized into four categories: production line (mixing, filling and baking), packaging, sanitation and warehouse (all included as part of cost of goods sold).
Administration Salaries: Includes taxes and benefits for the Vice President of Operations, the Controller, Human Resources Manager and two administrative support people.
Supplies: Includes supplies relating to production, packaging and decorating, sanitation and warehouse (think: adhesive, pastry bags, spatulas, scrapers, icing pens, gloves and so on).
Freight & Shipping-In: The costs of shipping raw ingredients and other materials to the factory from suppliers.
Freight & Shipping-Out: The costs of shipping finished products to customer locations and distribution centers.
Utilities Electricity: Approximately 10% for administrative office and the remainder for the factory. The factory portion varies somewhat with production volume.
Utilities Gas (ovens): Approximately 5% for administrative office and the remainder for the factory. The factory portion varies somewhat with production volume.
Water: All for the factory and varies proportionately with production volume.
Repairs & Maintenance: All for the factory.
Rent expense: The factory uses about 85% of the total square footage of the building and the remainder is for the administrative office.
Telephone & Internet: All for the administrative office.
Co-owners' salary: Elizabeth Madrid and Alicia Lee.
Brokers' commissions: Generally, 4% of sales.
Income Tax: Average total tax rate is 32%.
Your team's assignment
Elizabeth and Alicia are asking several firms to provide a proposal recommending what type of costing approach will help them determine more accurate cost information for Piece of Cake Pies' pricing and product decisions. Your firm has been invited to provide a proposal. 1000 words summary addressing the following questions (charts and tables with numerical values and calculations will not be included in the word count):
1 What information does Piece of Cake Pies need? Before recommending a cost system, it is helpful to understand a company's information needs. Based on case information, discuss the types of cost information Piece of Cake Pies' product costing system should be able to provide.
2 Of the expenses listed in Table 1, determine which should be treated as product costs and which should be treated as period costs for management decision making?
3 For each product cost you identified, how would you track the cost? For example, would you track it by individual job, batch, production step, activity, general factory overhead, etc.? Separate raw materials into main ingredients and flavor additives. Also, separate bakery labor into four categories: production line (includes mixing, filling and baking), packaging, sanitation and warehouse.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started