Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Puget Concrete is a major west coast supplier of concrete to residential and commercial builders with multiple sites in the Puget Sound area. Concrete is
Puget Concrete is a major west coast supplier of concrete to residential and commercial builders with multiple sites in the Puget Sound area. Concrete is sold (priced) by the cubic yard including costs based on number of cubic tards, delivery costs based on miles driven, and number of truck-hours while at the job site. The company's pricing policy is to price orders for concrete at 25% over full cost per cubic yard for the order. Full cost includes variable costs for concrete, delivery and yard operations plus an allocation for the estimated annual fixed costs of delivery, site operations and administrative costs (see 2017 cost estimates below). | |||||
Delivery costs include a rate per mile, recognizing that more miles means more gas and maintenance costs, plus a rate per truck-hour (hours on the job) since if kept waiting on a job site the truck must be kept running so the concrete will not harden and the driver must be paid for that time. Site operations is the name for the company's place where the concrete is prepared and loaded in the truck for delivery. | |||||
The price per cubic foot quoted the customer is based on full cost for the job plus 25% divided by number of cubic yards for the order as follows: | |||||
Jobs (orders) are priced as follows (using cost plus method): | |||||
Number of yards x Concrete cost/yard* | * need to compute cost per yard based on cost data below | ||||
Number of Miles driven x $10 per mile | using the planned miles for that order | ||||
Number of Truck hours x $50 per hour | using the planned hours for that order | ||||
Total Job Cost | |||||
plus Markup (job cost x 25%) | |||||
Total Price for the order | |||||
Total price divided by number of cu yds ordered is the quoted price per cu yd (includes delivery) | |||||
At the start of 2017, the company estimated their costs as follows: | |||||
Costs included in concrete cost/yard: | |||||
Direct Material cost = $75 per cubic yard | |||||
Variable site operations costs = $17 per cubic yard | |||||
Fixed site operations costs = $300,000 per year | |||||
Fixed Delivery costs = $500,000 per year | |||||
Fixed Admin. costs = $2,125,000 per year | |||||
Costs included in delivery cost: | |||||
Variable Delivery costs = $10 per mile + $50 per truck hour | |||||
And estimated 2017 sales volume is as follows: | |||||
Annual totals (planned): | 2017 amount | ||||
Total Cubic Yds to be delivered (sold) | 500,000 | ||||
Total Delivery Miles | 700,000 | ||||
Total Truck-hours | 25,000 | ||||
Total number of jobs (orders) | 100 |
Q3 |
Puget has multiple operating sites but does not perform cost or profit analysis by site. The CFO suggests a report be developed based on a breakout of the North and South Puget Sound yard locations. Two overhead allocation methods are under review using prior year data for analysis: | |||
Overhead costs | Annual Amount | |||
Employee Benefits | $1,700,000 | |||
Rent & Utilities | $500,000 | |||
Other Ops overhead | $1,800,000 | |||
Total OH | $4,000,000 | |||
Site information: | North | South | ||
Sales | $20,000,000 | $47,000,000 | ||
Number of employees | 20 | 35 | ||
Site Building Size | 6,000 sq ft. | 6,000 sq ft. | ||
Required: Prepare an overhead allocation report for North and South sites using (Method 1) Sales $ to allocate total OH between the two, and (Method 2) # employees for Employee Benefits, Building space used for rent & utilities, and Sales $ for Other Ops Overhead costs. Show the difference in results and explain which method you recommend and why. | ||||
Q4 | Puget currently charges $10/mile to cover the variable costs of delivery and includes the $500,000 annual fixed cost related to delivery in the cost of concrete. Now they are considering using a new cost per mile rate that covers both their fixed and variable costs. Required: Given the planned number of annual delivery miles, 700,000, what rate per mile must they charge to break even (no profit markup) on their total delivery costs? (show calculations) | |||
Q5 | Puget's CFO will be meeting with the bank to apply for a loan, he had the following report parepared to meet the bank's request. Review the trends based on the this data and answer the questions below to prepare for the bank meeting: | |||
Report of key ratios for last three years: | 2016 | 2015 | 2014 | |
Current ratio | 2.6:1 | 2.4:1 | 2.2:1 | |
Current assets / Current liabilities | ||||
Acid test (quick ratio) | 0.9:1 | 1.0:1 | 1.1:1 | |
(Cash + Short-term receivables) / Current liabilities | ||||
Accounts receivable turnover | 9.2 times | 10.3 times | 11.5 times | |
Net credit sales / Accounts receivable | ||||
Inventory turnover | 8.1 times | 7.8 times | 6.2 times | |
Cost of goods sold / Inventory | ||||
Return on total assets | 14.5% | 13.1% | 11.3% | |
(Net income + [Interest expense x (1-Tax rate)]) / Total assets | ||||
Return on common stockholders equity | 17.2% | 15.1% | 12.9% | |
Net income / Stockholders equity | ||||
Priceearnings ratio | 14.5 | 17.2 | 17.8 | |
Market price per share / Earnings per share | ||||
Earnings per share | $1.52 | $1.51 | $1.54 | |
Net income / Number of common shares outstanding | ||||
Note: There has been no change in number of shares outstanding. |
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