In: Accounting
Diversified Industries manufactures sump-pumps. Its most popular product is called the Super Soaker, which has a retail price of $1,200 and costs $540 to manufacture. It sells the Super Soaker on a standalone basis directly to businesses. Diversified also provides installation services for these commercial customers, who want an emergency pumping capability (with regular and back-up generator power) at their businesses. Diversified also distributes the Super Soaker through a consignment agreement with Menards. Income data for the first quarter of 2017 from operations other than the Super Soaker are as follows. Revenues $9,500,000 Expenses ?7,750,000 Diversified has the following information related to two Super Soaker revenue arrangements during the first quarter of 2017. 1.Diversified sells 30 Super Soakers to businesses in flood-prone areas for a total contract price of $54,600. In addition to the pumps, Diversified also provides installation (at a cost of $150 per pump). On a standalone basis, the fair value of this service is $200 per unit installed. The contract payment also includes a $10 per month service plan for the pumps for 3 years after installation (Diversified's cost to provide this service is $7 per month). The Super Soakers are delivered and installed on March 1, 2017, and full payment is made to Diversified. Any discount is applied to the pump/installation bundle. 2.Diversified ships 300 Super Soakers to Menards on consignment. By March 31, 2017, Menards has sold two-thirds of the consigned merchandise at the listed price of $1,200 per unit. Menards notifies Diversified of the sales, retains a 5% commission, and remits the cash due Diversified.
Accounting:Determine Diversified Industries' 2017 first-quarter net income. (Ignore taxes.)
Analysis: Determine free cash flow for Diversified Industries for the first quarter of 2017. In the first quarter, Diversified had depreciation expense of $175,000 and a net increase in working capital (change in accounts receivable and accounts payable) of $250,000. In the first quarter, capital expenditures were $500,000; Diversified paid dividends of $120,000.
Net income for the first Quarter = $1,493,340.
Working:
| Revenue from other products | 9500000 | 
| Revenue from Super Soaker | 54600 | 
| Consignment Sales Revenue (200*1200) | 240000 | 
| Total Revenue (A) | 9554600 | 
| Expenses: | |
| Expenses for other products | 7750000 | 
| Expenses for asuper Soaker (942*30) * | 28260 | 
| Cost of consignment sales (200*540) | 108000 | 
| Depreciation Expense | 175000 | 
| Total Expenses (B) | 8061260 | 
| Net income (A - B) | 1493340 | 
| Number of units sold | 30 | 
| Sale value | 54600 | 
| Price per unit | 1820 | 
| Stand alone price | 1200 | 
| Fair value of Installation per unit | 200 | 
| Service plan charge for three year ($10 per month) | 360 | 
| total | 1760 | 
| Allocation of the price of $1,820 | |
| Sale price of the unit (1820/1760)*1200 | 1241 | 
| Installation revenue (1820/1760)*200 | 207 | 
| Service Plan Revenue (1820/1760)*360 | 372 | 
| 1820 | |
| Cost for the above activities | |
| Unit cost price | 540 | 
| Cost of the installation | 150 | 
| Cost for the service plan (7*12*3) | 252 | 
| Total Cost * | 942 | 
| Free Cash flow | |
| Net income | 1493340 | 
| Add: Depreciation Expense | 175000 | 
| Less: Increase in working Capital | -250000 | 
| Net cash flow from operating activities | 1418340 | 
| Les: Capital Expenses | -500000 | 
| Free cash flows | 918340 |