Please see attached.
1 Excel Spreadsheet - Completed Customer Demand Data spreadsheet
1 Memo Report - Analysis of Current and Proposed Pricing Strategy for Profitability
? Include an assessment of whether the current fare maximizes profits. If not, identify the fare that should be charged. Give evidence that it is the best by showing that profits are highest if this fare is charged.
? Complete the Customer Demand Data spreadsheet for Clear Blue Sky by calculating all appropriate revenues, costs, and profits.
? Discuss whether fuel costs should be used as a basis for pricing.
? Comment on the suggestion that the company could use price-discrimination strategies to improve profitability.
? Discuss the requirements for effective price discrimination, and describe how Clear Blue Sky satisfies these requirements.
? Identify and describe each group of travelers according to their price sensitivity. Analyze the price elasticity of demand for each group.
? Recommend a pricing plan that effectively separates each group of consumers. Providing actual prices is not necessary, but your plan should clearly indicate the level of pricing for each group.
Pricing analysis is achieved.
Cost Accounting Questions and 3 Cost Analysis Problems
1. Cost of goods manufactured during a period is obtained by taking the total manufacturing costs incurred during the period, adding, and subtracting the following inventories:
a. Beginning finished goods inventory Ending finished goods inventory
b. Beginning work in process inventory Ending finished goods inventory
c. Beginning raw materials inventory Ending work in process inventory
d. Beginning work in process inventory Ending work in process inventory
2. Cost of goods sold is equal to
a. total manufacturing costs plus beginning work in process less ending work in process.
b. cost of goods sold plus beginning work in process less ending work in process.
c. total manufacturing costs plus ending work in process less beginning work in process.
d. cost of goods manufactured plus beginning finished goods less ending finished goods.
3. Inventory accounts for a manufacturer consist of
a. direct materials, work in process, and finished goods.
b. direct labor, work in process, and finished goods.
c. manufacturing overhead, direct materials, and direct labor.
d. work in process, direct labor, and manufacturing overhead.
4. In a process cost system, equivalent units of production are the
a. work done on physical units expressed in fully completed units.
b. units that are transferred to the next processing department.
c. units completed and transferred to finished goods.
d. units that are incomplete at the end of a period.
Use the following information for questions 5 and 6.
In the month of November, a department had 500 units in the beginning work in process inventory that were 60% complete. These units had $8,000 of materials cost and $6,000 of conversion costs. Materials are added at the beginning of the process and conversion costs are added uniformly throughout the process. During November, 10,000 units were completed and transferred to the finished goods inventory and there were 2,000 units that were 25% complete in the ending work in process inventory on April 30. During November, manufacturing costs charged to the department were: Materials $184,000; Conversion costs $204,000.
5. The cost assigned to the units transferred to finished goods during November was
6. The cost assigned to the units in the ending work in process inventory on November 30 was
7. An appropriate cost driver for ordering and receiving materials cost is the
a. direct labor hours.
b. machine hours.
c. number of parts.
d. number of purchases orders.
8. Benefits of activity-based costing include all of the following except
a. more accurate product costing.
b. fewer cost pools used to assign overhead costs to products.
c. enhanced control over overhead costs.
d. better management decisions.
9. An example of a value-added activity in a manufacturing operation is
a. machine repair.
b. inventory control.
c. engineering design.
d. building maintenance.
10. Assigning manufacturing costs to work in process results in credits to all of the following accounts except
a. Factory Labor.
b. Manufacturing Overhead.
c. Raw Materials Inventory.
d. Work in Process Inventory.
11. Juniper, Inc. sells a single product with a contribution margin of $12 per unit and fixed costs of $74,400 and sales for the current year of $100,000. How much is Juniper's break even point?
a. 4,600 units
c. 6,200 units
d. 2,133 units
12. Homer Company's variable costs are 30% of sales. The company is contemplating an advertising campaign that will cost $22,000. If sales are expected to increase $40,000, by how much will the company's net income increase?
d . $12,000
13. Twix Company sells two products, beer and wine. Beer has a 10 percent profit margin and wine has a 12 percent profit margin. Beer has a 27 percent contribution margin and wine has a 25 percent contribution margin. If other factors are equal, which product should Twix push to customers?
c. Selling either results in the same additional income for the company
d. It should sell an equal quantity of both.
14. Monroe Company manufactures a product with a unit variable cost of $42 and a unit sales price of $75. Fixed manufacturing costs were $80,000 when 10,000 units were produced and sold, equating to $8 per unit. The company has a one-time opportunity to sell an additional 1,000 units at $55 each in an international market which would not affect its present sales. The company has sufficient capacity to produce the additional units. How much is the relevant income effect of accepting the special order?
15. Beavers, Inc. is unsure of whether to sell its product assembled or unassembled. The unit cost of the unassembled product is $16, while the cost of assembling each unit is estimated at $17. Unassembled units can be sold for $55, while assembled units could be sold for $71 per unit. What decision should Beavers make?
a. Sell before assembly, the company will save $1 per unit.
b. Sell before assembly, the company will save $15 per unit.
c. Process further, the company will save $1 per unit.
d. Process further, the company will save $16 per unit.
16. Lion Company sells office chairs with a selling price of $25 and a contribution margin per unit of $15. It takes 3 machine hours to produce one chair. How much is the contribution margin per unit of limited resource?
Use the following information for items 17 -19.
Dustin Company sells its product for $40 per unit. During 2005, it produced 60,000 units and sold 50,000 units (there was no beginning inventory). Costs per unit are: direct materials $10, direct labor $6, and variable overhead $2. Fixed costs are: $480,000 manufacturing overhead, and $60,000 selling and administrative expenses.
17. The per unit manufacturing cost under absorption costing is:
18. The per unit manufacturing cost under variable costing is:
19. Cost of goods sold under absorption costing is:
a. $ 900,000.
20. A company developed the following per-unit standards for its product: 2 pounds of direct materials at $6 per pound. Last month, 2,000 pounds of direct materials were purchased for $11,400. The direct materials price variance for last month was
a. $11,400 favorable.
b. $600 favorable.
c. $300 favorable.
d. $600 unfavorable.
21. The per-unit standards for direct materials are 2 gallons at $4 per gallon. Last month, 11,200 gallons of direct materials that actually cost $42,400 were used to produce 6,000 units of product. The direct materials quantity variance for last month was
a. $3,200 favorable.
b. $2,400 favorable.
c. $3,200 unfavorable.
d. $5,600 unfavorable.
22. The per-unit standards for direct labor are 2 direct labor hours at $12 per hour. If in producing 2,400 units, the actual direct labor cost was $51,200 for 4,000 direct labor hours worked, the total direct labor variance is
a. $1,920 unfavorable.
b. $6,400 favorable.
c. $4,000 unfavorable.
d. $6,400 unfavorable.
23. The standard rate of pay is $5 per direct labor hour. If the actual direct labor payroll was $19,600 for 4,000 direct labor hours worked, the direct labor price (rate) variance is
a. $800 unfavorable.
b. $800 favorable.
c. $1,000 unfavorable.
d. $400 favorable.
24. The standard number of hours that should have been worked for the output attained is 8,000 direct labor hours and the actual number of direct labor hours worked was 8,400. If the direct labor price variance was $8,400 unfavorable, and the standard rate of pay was $18 per direct labor hour, what was the actual rate of pay for direct labor?
a. $17.00 per direct labor hour
b. $15.00 per direct labor hour
c. $19.00 per direct labor hour
d. $18.00 per direct labor hour
Problem 1 - Activity-Based Costing (16 points)
Tuttle Manufacturing Company manufactures two products: radiators and gas tanks. During June, 200 radiators and 400 gas tanks were produced and overhead costs of $54,000 were incurred. The following information related to overhead costs was available:
Activity Cost Driver Total Cost
Materials handling Number of requisitions $24,000
Machine setups Number of setups 18,000
Quality inspections Number of inspections 20,000
The cost driver volume for each product was as follows:
Cost Driver Radiators Gas Tanks Total
Number of requisitions 300 500 800
Number of setups 140 220 360
Number of inspections 190 310 500
a) Compute the overhead rate for each activity.
b) Assign the manufacturing overhead costs for June to the two products using activity-based costing.
Problem 2 - Cost-Volume-Profit (20 points)
Reavis Company prepared the following income statement for 2005:
For the Year Ended December 31, 2005
Sales (20,000 units) $600,000
Variable expenses 360,000
Contribution margin 240,000
Fixed expenses 180,000
Net income $ 60,000
Answer the following independent questions and show computations to support your answers.
1) What is the company's break-even point in units?
2) How many more units would the company have had to sell to earn net income of $90,000 in 2005?
3) If the company expects a 25% increase in sales volume in 2006, what would be the expected net income in 2006?
4) How much sales dollars would the company have to generate in order to earn a target net income of $110,000 in 2006?
Problem 3 - Standard Costing ( 16 points)
Beachwalk Company uses a standard cost accounting system. During January, 2006, the company reported the following manufacturing variances:
Material price variance $2,000 F
Material quantity variance 2,400 U
Labor price variance 800 U
Labor quantity variance 1,200 U
Overhead controllable 500 F
Overhead volume 3,000 U
In addition, 15,000 units of product were sold at $18 per unit. Each unit sold had a standard cost of $12. Selling and administrative expenses for the month were $10,000.
Prepare an income statement for management for the month ending January 31, 2006.