A dynamometer test lab currently has 45 computers with 20 printers. The computers cost $3,500 each and the printers were $350 each when purchased 2 years ago. The market value of the computers is estimated at $750 each today and the printers $75 each today. It is expected that the current equipment will last another 4 years and have no salvage value at that time. Operating expenses are $350 for each computer and $150 for each printer per year.
A new networked system is being considered that would have 45 terminal with a cost of $2.500 each; 7 printers would be purchased at $1000 each. The life of the new system is 6 years with a salvage value of $500 for the terminals and $400 for the printers at the end of that time. Operating expenses for the networked system are $6,000 per year.
A) What are the sunk costs at this point? (5 points)
B) If the firm desires a 15% IRR, determine the best alternative. (20 points)
Show ALL work.
In: Accounting
| Input Data | |||||||||||||||||||||||||
| Month | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| Revenue | $ - | $ - | $ - | $ - | $ - | $ - | $ 2,500 | $ 2,875 | $ 3,306 | $ 3,802 | $ 4,373 | $ 5,028 | $ 5,783 | $ 6,650 | $ 7,648 | $ 8,795 | $ 10,114 | $ 11,631 | $ 13,376 | $ 15,382 | $ 17,689 | $ 20,343 | $ 23,394 | $ 26,903 | |
| Monthly Revenue Growth Rate | 0% | 0% | 0% | 0% | 0% | 0% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | |
| Terms of Revenue | |||||||||||||||||||||||||
| Cash Sales (% of revenue) | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | |
| N30 (% of revenue) | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | |
| N60 (% of revenue) | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| Cost of Good Sold | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | |
| Terms of Cost of Goods Sold | |||||||||||||||||||||||||
| Cash Sales (% of purchases) | 0% | 0% | 0% | 0% | 0% | 0% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | |
| N30 (% of purchases) | 0% | 0% | 0% | 0% | 0% | 0% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | |
| N60 (% of purchases) | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| Cash Operating Costs | |||||||||||||||||||||||||
| Compensation | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| Rent | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | |
| Supplies | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | |
| Other Operating Expences | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | |
| Accounting | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $115 | $132 | $152 | $175 | $201 | $231 | $266 | $306 | $352 | $405 | $465 | $535 | $615 | $708 | $814 | $936 | $1,076 | |
| Advertizing | $350 | 350 | 350 | 350 | 350 | 350 | 403 | 463 | 532 | 612 | 704 | 810 | 931 | 1071 | 1231 | 1416 | 1628 | 1873 | 2153 | 2476 | 2848 | 3275 | 3766 | 4331 | |
| Tax Rate | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| Income Statement | |||||||||||||||||||||||||
| Month | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $2,500 | $2,875 | $3,306 | $3,802 | $4,373 | $5,028 | $5,783 | $6,650 | $7,648 | $8,795 | $10,114 | $11,631 | $13,376 | $15,382 | $17,689 | $20,343 | $23,394 | $26,903 | |
| Cost of Goods Sold | $0 | $0 | $0 | $0 | $0 | $0 | $200 | $230 | $265 | $304 | $350 | $402 | $463 | $532 | $612 | $704 | $809 | $930 | $1,070 | $1,231 | $1,415 | $1,627 | $1,872 | $2,152 | |
| Gross Profit | $0 | $0 | $0 | $0 | $0 | $0 | $2,300 | $2,645 | $3,042 | $3,498 | $4,023 | $4,626 | $5,320 | $6,118 | $7,036 | $8,091 | $9,305 | $10,701 | $12,306 | $14,151 | $16,274 | $18,715 | $21,523 | $24,751 | |
| Compensation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Rent | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | |
| Supplies | 0 | 0 | 0 | 0 | 0 | 0 | 250 | 288 | 331 | 380 | 437 | 503 | 578 | 665 | 765 | 879 | 1,011 | 1,163 | 1,338 | 1,538 | 1,769 | 2,034 | 2,339 | 2,690 | |
| Other operating Expences | 0 | 0 | 0 | 0 | 0 | 0 | 375 | 431 | 496 | 570 | 656 | 754 | 867 | 998 | 1,147 | 1,319 | 1,517 | 1,745 | 2,006 | 2,307 | 2,653 | 3,051 | 3,509 | 4,035 | |
| Accounting | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | |
| Advertizing | 350 | 350 | 350 | 350 | 350 | 350 | 403 | 463 | 532 | 612 | 704 | 810 | 931 | 1,071 | 1,231 | 1,416 | 1,628 | 1,873 | 2,153 | 2,476 | 2,848 | 3,275 | 3,766 | 4,331 | |
| Earnings Before Taxes | -$650 | -$650 | -$650 | -$650 | -$650 | -$650 | $973 | $1,163 | $1,383 | $1,635 | $1,926 | $2,259 | $2,643 | $3,085 | $3,593 | $4,176 | $4,848 | $5,620 | $6,508 | $7,529 | $8,704 | $10,054 | $11,608 | $13,394 | |
| Taxes | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Income | -$650 | -$650 | -$650 | -$650 | -$650 | -$650 | $973 | $1,163 | $1,383 | $1,635 | $1,926 | $2,259 | $2,643 | $3,085 | $3,593 | $4,176 | $4,848 | $5,620 | $6,508 | $7,529 | $8,704 | $10,054 | $11,608 | $13,394 | |
| Cash Flow | |||||||||||||||||||||||||
| Cash Collected from Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $1,750 | $2,763 | $3,177 | $3,653 | $4,201 | $4,832 | $5,556 | $6,390 | $7,348 | $8,451 | $9,718 | $11,176 | $12,852 | $14,780 | $16,997 | $19,547 | $22,479 | $25,850 | |
| Cash Payments on COGS | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $200 | $230 | $265 | $304 | $350 | $402 | $463 | $532 | $612 | $704 | $809 | $930 | $1,070 | $1,231 | $1,415 | $1,627 | $1,872 | |
| Cash Operating Expenses ETC | $650 | $650 | $650 | $650 | $650 | $650 | $1,328 | $1,482 | $1,659 | $1,863 | $2,097 | $2,367 | $2,677 | $3,033 | $3,443 | $3,915 | $4,457 | $5,080 | $5,797 | $6,622 | $7,570 | $8,661 | $9,915 | $11,357 | |
| Taxes | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Cash Flow | -$650 | -$1,301 | -$1,951 | -$2,601 | -$3,251 | -$3,902 | -$3,479 | -$2,398 | -$1,110 | $416 | $2,216 | $4,331 | $6,809 | $9,703 | $3,373 | $3,924 | $4,558 | $5,286 | $6,124 | $7,088 | $8,196 | $9,471 | $10,936 | $12,622 | |
| Cash Account Balance | $3,000 | $2,350 | $1,049 | -$902 | -$3,503 | -$6,754 | -$10,655 | -$14,134 | -$16,532 | -$17,642 | -$17,226 | -$15,010 | -$10,679 | -$3,870 | $5,833 | $9,206 | $13,130 | $17,688 | $22,974 | $29,099 | $36,187 | $44,383 | $53,854 | $64,790 | $77,412 |
Compute, if possible, how much revenue would be needed to breakeven in terms of cash flow. Comment on the financial viability of the venture. Would you suggest any changes? If so, what are they? If you do, this becomes your ‘base’ model.
In: Accounting
| Input Data | |||||||||||||||||||||||||
| Month | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| Revenue | $ - | $ - | $ - | $ - | $ - | $ - | $ 2,500 | $ 2,875 | $ 3,306 | $ 3,802 | $ 4,373 | $ 5,028 | $ 5,783 | $ 6,650 | $ 7,648 | $ 8,795 | $ 10,114 | $ 11,631 | $ 13,376 | $ 15,382 | $ 17,689 | $ 20,343 | $ 23,394 | $ 26,903 | |
| Monthly Revenue Growth Rate | 0% | 0% | 0% | 0% | 0% | 0% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | |
| Terms of Revenue | |||||||||||||||||||||||||
| Cash Sales (% of revenue) | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | |
| N30 (% of revenue) | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | |
| N60 (% of revenue) | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| Cost of Good Sold | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | 8% | |
| Terms of Cost of Goods Sold | |||||||||||||||||||||||||
| Cash Sales (% of purchases) | 0% | 0% | 0% | 0% | 0% | 0% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | 70% | |
| N30 (% of purchases) | 0% | 0% | 0% | 0% | 0% | 0% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | 30% | |
| N60 (% of purchases) | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| Cash Operating Costs | |||||||||||||||||||||||||
| Compensation | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| Rent | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | |
| Supplies | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | 10% | |
| Other Operating Expences | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | |
| Accounting | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $115 | $132 | $152 | $175 | $201 | $231 | $266 | $306 | $352 | $405 | $465 | $535 | $615 | $708 | $814 | $936 | $1,076 | |
| Advertizing | $350 | 350 | 350 | 350 | 350 | 350 | 403 | 463 | 532 | 612 | 704 | 810 | 931 | 1071 | 1231 | 1416 | 1628 | 1873 | 2153 | 2476 | 2848 | 3275 | 3766 | 4331 | |
| Tax Rate | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |
| Income Statement | |||||||||||||||||||||||||
| Month | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $2,500 | $2,875 | $3,306 | $3,802 | $4,373 | $5,028 | $5,783 | $6,650 | $7,648 | $8,795 | $10,114 | $11,631 | $13,376 | $15,382 | $17,689 | $20,343 | $23,394 | $26,903 | |
| Cost of Goods Sold | $0 | $0 | $0 | $0 | $0 | $0 | $200 | $230 | $265 | $304 | $350 | $402 | $463 | $532 | $612 | $704 | $809 | $930 | $1,070 | $1,231 | $1,415 | $1,627 | $1,872 | $2,152 | |
| Gross Profit | $0 | $0 | $0 | $0 | $0 | $0 | $2,300 | $2,645 | $3,042 | $3,498 | $4,023 | $4,626 | $5,320 | $6,118 | $7,036 | $8,091 | $9,305 | $10,701 | $12,306 | $14,151 | $16,274 | $18,715 | $21,523 | $24,751 | |
| Compensation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Rent | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | |
| Supplies | 0 | 0 | 0 | 0 | 0 | 0 | 250 | 288 | 331 | 380 | 437 | 503 | 578 | 665 | 765 | 879 | 1,011 | 1,163 | 1,338 | 1,538 | 1,769 | 2,034 | 2,339 | 2,690 | |
| Other operating Expences | 0 | 0 | 0 | 0 | 0 | 0 | 375 | 431 | 496 | 570 | 656 | 754 | 867 | 998 | 1,147 | 1,319 | 1,517 | 1,745 | 2,006 | 2,307 | 2,653 | 3,051 | 3,509 | 4,035 | |
| Accounting | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | |
| Advertizing | 350 | 350 | 350 | 350 | 350 | 350 | 403 | 463 | 532 | 612 | 704 | 810 | 931 | 1,071 | 1,231 | 1,416 | 1,628 | 1,873 | 2,153 | 2,476 | 2,848 | 3,275 | 3,766 | 4,331 | |
| Earnings Before Taxes | -$650 | -$650 | -$650 | -$650 | -$650 | -$650 | $973 | $1,163 | $1,383 | $1,635 | $1,926 | $2,259 | $2,643 | $3,085 | $3,593 | $4,176 | $4,848 | $5,620 | $6,508 | $7,529 | $8,704 | $10,054 | $11,608 | $13,394 | |
| Taxes | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Income | -$650 | -$650 | -$650 | -$650 | -$650 | -$650 | $973 | $1,163 | $1,383 | $1,635 | $1,926 | $2,259 | $2,643 | $3,085 | $3,593 | $4,176 | $4,848 | $5,620 | $6,508 | $7,529 | $8,704 | $10,054 | $11,608 | $13,394 | |
| Cash Flow | |||||||||||||||||||||||||
| Cash Collected from Revenue | $0 | $0 | $0 | $0 | $0 | $0 | $1,750 | $2,763 | $3,177 | $3,653 | $4,201 | $4,832 | $5,556 | $6,390 | $7,348 | $8,451 | $9,718 | $11,176 | $12,852 | $14,780 | $16,997 | $19,547 | $22,479 | $25,850 | |
| Cash Payments on COGS | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $200 | $230 | $265 | $304 | $350 | $402 | $463 | $532 | $612 | $704 | $809 | $930 | $1,070 | $1,231 | $1,415 | $1,627 | $1,872 | |
| Cash Operating Expenses ETC | $650 | $650 | $650 | $650 | $650 | $650 | $1,328 | $1,482 | $1,659 | $1,863 | $2,097 | $2,367 | $2,677 | $3,033 | $3,443 | $3,915 | $4,457 | $5,080 | $5,797 | $6,622 | $7,570 | $8,661 | $9,915 | $11,357 | |
| Taxes | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Net Cash Flow | -$650 | -$1,301 | -$1,951 | -$2,601 | -$3,251 | -$3,902 | -$3,479 | -$2,398 | -$1,110 | $416 | $2,216 | $4,331 | $6,809 | $9,703 | $3,373 | $3,924 | $4,558 | $5,286 | $6,124 | $7,088 | $8,196 | $9,471 | $10,936 | $12,622 | |
| Cash Account Balance | $3,000 | $2,350 | $1,049 | -$902 | -$3,503 | -$6,754 | -$10,655 | -$14,134 | -$16,532 | -$17,642 | -$17,226 | -$15,010 | -$10,679 | -$3,870 | $5,833 | $9,206 | $13,130 | $17,688 | $22,974 | $29,099 | $36,187 | $44,383 | $53,854 | $64,790 | $77,412 |
If an angel offered funding of $30,000 for 40% of your company, how would you view the angel’s offer?
In: Accounting
Question 7 (7 points)
During June, Bravo Magazine sold for cash six advertising spaces for $400 each to be run in the July through December issues. On that date, Bravo properly recognized Unearned Revenue. The adjusting entry to record on July 31 includes:
Question 7 options:
|
a debit to Cash for $2,000 |
|
|
a debit to Unearned Revenue for $400 |
|
|
a credit to Revenue for $2,000 |
|
|
a credit to Unearned Revenue for $400 |
Question 8 (7 points)
On January 7, Bravo purchased supplies on account for $1,000, and recorded this purchase to the Supplies account. At the end of January, Bravo had $600 of these supplies still on hand. The proper adjusting journal entry at January 31 would:
Question 8 options:
|
include a credit to Supplies for $400 |
|
|
include a debit to Supplies Expense for $600 |
|
|
include a debit to Accounts Payable for $400 |
|
|
include a debit to Supplies for $1,000 |
In: Accounting
You may need to use the appropriate appendix table to answer this question.
According to Money magazine, Maryland had the highest median annual household income of any state in 2018 at $75,847. Assume that annual household income in Maryland follows a normal distribution with a median of $75,847 and standard deviation of $33,800.
(a)
What is the probability that a household in Maryland has an annual income of $90,000 or more? (Round your answer to four decimal places.)
(b)
What is the probability that a household in Maryland has an annual income of $50,000 or less? (Round your answer to four decimal places.)
(c)
What is the probability that a household in Maryland has an annual income between $40,000 and $70,000? (Round your answer to four decimal places.)
(d)
What is the annual income (in $) of a household in the ninety-first percentile of annual household income in Maryland? (Round your answer to the nearest cent.)
In: Statistics and Probability
January of 1999, the German Auto Bild magazine randomly tested different tread patterns across all tire brands as their journalists toured from the UK to the Bulgarian coast. They discovered on one leg of the tour that out of 100 tires, or 12%, shortcomings were due to defective sidewall wire. On another leg they found 125 tires, 15% of the defects were due to poor vulcanization.
a) Find an appropriate 95% confidence interval. Explain the difference in outcomes. Let poor vulcanization represent sample #1.
b) Use your confidence interval to explain the difference in outcomes. 2
c) An expert at TUV thought defects due to wire imperfections were more common than poor vulcanization issues. Reexamine the question in part “b” using a hypothesis test to determine if you support this German regulator’s expert opinion?
In: Statistics and Probability
Vaughn Magazine sold 9,480 annual subscriptions on August 1, 2020, for $13 each. Prepare Vaughn’s August 1, 2020, journal entry and the December 31, 2020, annual adjusting entry, assuming the magazines are published and delivered monthly. (If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Credit account titles are automatically indented when amount is entered. Do not indent manually. Record journal entries in the order presented in the problem.) Date Account Titles and Explanation Debit Credit choose a transaction date enter an account title enter a debit amount enter a credit amount enter an account title enter a debit amount enter a credit amount choose a transaction date enter an account title enter a debit amount enter a credit amount enter an account title enter a debit amount enter a credit amount
In: Accounting
A magazine provided overall customer satisfaction scores for AT&T, Sprint, T-Mobile, and Verizon cell-phone services in major metropolitan areas throughout the United States. The rating for each service reflects the overall customer satisfaction considering a variety of factors such as cost, connectivity problems, dropped calls, static interference, and customer support. A satisfaction scale from 0 to 100 was used with indicating 0 completely dissatisfied and 100 indicating completely satisfied. The ratings for the four cell-phone services in 20 metropolitan areas are as shown.
| Metropolitan Area | AT&T | Sprint | T-Mobile | Verizon |
|---|---|---|---|---|
| Atlanta | 70 | 63 | 77 | 80 |
| Boston | 69 | 61 | 80 | 77 |
| Chicago | 71 | 62 | 76 | 78 |
| Dallas | 75 | 62 | 80 | 79 |
| Denver | 71 | 64 | 79 | 78 |
| Detroit | 73 | 62 | 83 | 80 |
| Jacksonville | 73 | 61 | 81 | 82 |
| Las Vegas | 72 | 65 | 80 | 82 |
| Los Angeles | 66 | 62 | 74 | 79 |
| Miami | 68 | 66 | 79 | 81 |
| Minneapolis | 68 | 63 | 81 | 78 |
| Philadelphia | 72 | 63 | 77 | 79 |
| Phoenix | 68 | 63 | 82 | 82 |
| San Antonio | 75 | 62 | 81 | 81 |
| San Diego | 69 | 65 | 78 | 80 |
| San Francisco | 66 | 66 | 79 | 76 |
| Seattle | 68 | 64 | 80 | 78 |
| St. Louis | 74 | 63 | 80 | 80 |
| Tampa | 73 | 60 | 79 | 80 |
| Washington | 72 | 65 | 77 | 77 |
a. Consider T-Mobile first. What is the median rating (to 1 decimal)?
b. Develop a five-number summary for the T-Mobile service.
| Smallest value | |
| First quartile (to 2 decimals) | |
| Median (to 1 decimal) | |
| Third quartile (to 2 decimals) | |
| Largest value |
c. Are there outliers for T-Mobile? Explain.
All ratings are between and .
- Select your answer -Yes, the data contain outliersNo, the data do not contain outliersItem 9
d. Repeat parts (b) and (c) for the other three cell-phone services.
| AT&T | Sprint | Verizon | |
| Smallest value | |||
| First quartile (to 2 decimals) | |||
| Median (to 1 decimal) | |||
| Third quartile (to 2 decimals) | |||
| Largest value |
Are there outliers for AT&T? Explain.
Limits for AT&T(to 1 decimal) and
- Select your answer -Yes, the data contain outliersNo, the data do not contain outliersItem 27
Are there outliers for Sprint? Explain.
Limits for Sprint(to 2 decimals) and
- Select your answer -Yes, the data contain outliersNo, the data do not contain outliersItem 30
Are there outliers for Verizon? Explain.
Limits for Verizon(to 2 decimals) and
- Select your answer -Yes, the data contain outliersNo, the data do not contain outliersItem 33
e. Which of the following box plots accurately displays the data set?
| #1 | #2 | ||
| #3 | #4 |
- Select your answer -Box plot #1Box plot #2Box plot #3Box plot #4Item 34
Which service did the magazine recommend as being best in terms of overall customer satisfaction?
- Select your answer -AT&TSprintT-MobileVerizonItem 35
Discuss what a comparison of the box plots tells about the four services.
- Select your answer -AT&T’sSprint’sT-Mobile’sVerizon’sItem 36 lowest rating is better than the highest - Select your answer -AT&T and SprintAT&T and VerizonSprint and VerizonT-Mobile and VerizonItem 37 ratings and is better than of the - Select your answer -AT&TSprintT-MobileVerizonItem 38 ratings. - Select your answer -AT&TSprintT-MobileVerizonItem 39 shows the lowest customer satisfaction ratings among the four services.
In: Statistics and Probability
1. Social Circle Publications Inc. is considering two new magazine products. The estimated net cash flows from each product are as follows:
| Year | Sound Cellar | Pro Gamer | ||||
| 1 | $ 65,000 | $ 70,000 | ||||
| 2 | 60,000 | 55,000 | ||||
| 3 | 25,000 | 35,000 | ||||
| 4 | 25,000 | 30,000 | ||||
| 5 | 45,000 | 30,000 | ||||
| Total | $220,000 | $220,000 | ||||
Each product requires an investment of $125,000. A rate of 10% has been selected for the net present value analysis.
| Present Value of $1 at Compound Interest | |||||
| Year | 6% | 10% | 12% | 15% | 20% |
| 1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
| 2 | 0.890 | 0.826 | 0.797 | 0.756 | 0.694 |
| 3 | 0.840 | 0.751 | 0.712 | 0.658 | 0.579 |
| 4 | 0.792 | 0.683 | 0.636 | 0.572 | 0.482 |
| 5 | 0.747 | 0.621 | 0.567 | 0.497 | 0.402 |
| 6 | 0.705 | 0.564 | 0.507 | 0.432 | 0.335 |
| 7 | 0.665 | 0.513 | 0.452 | 0.376 | 0.279 |
| 8 | 0.627 | 0.467 | 0.404 | 0.327 | 0.233 |
| 9 | 0.592 | 0.424 | 0.361 | 0.284 | 0.194 |
| 10 | 0.558 | 0.386 | 0.322 | 0.247 | 0.162 |
Required:
1a. Compute the cash payback period for each product.
| Cash Payback Period | |
| Sound Cellar | |
| Pro Gamer |
1b. Compute the net present value. Use the present value of $1 table above. If required, round to the nearest dollar.
| Sound Cellar | Pro Gamer | |
| Present value of net cash flow total | $ | $ |
| Less amount to be invested | $ | $ |
| Net present value | $ | $ |
2.
First United Bank Inc. is evaluating three capital investment projects by using the net present value method. Relevant data related to the projects are summarized as follows:
| Branch Office Expansion | Computer System Upgrade | ATM Kiosk Expansion | |||
| Amount to be invested . . . . . . . . . . . . . . . . . . . . . . . | $420,000 | $350,000 | $520,000 | ||
| Annual net cash flows: | |||||
| Year 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . | 200,000 | 190,000 | 275,000 | ||
| Year 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . | 160,000 | 180,000 | 250,000 | ||
| Year 3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . | 160,000 | 170,000 | 250,000 | ||
| Present Value of $1 at Compound Interest | |||||
| Year | 6% | 10% | 12% | 15% | 20% |
| 1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
| 2 | 0.890 | 0.826 | 0.797 | 0.756 | 0.694 |
| 3 | 0.840 | 0.751 | 0.712 | 0.658 | 0.579 |
| 4 | 0.792 | 0.683 | 0.636 | 0.572 | 0.482 |
| 5 | 0.747 | 0.621 | 0.567 | 0.497 | 0.402 |
| 6 | 0.705 | 0.564 | 0.507 | 0.432 | 0.335 |
| 7 | 0.665 | 0.513 | 0.452 | 0.376 | 0.279 |
| 8 | 0.627 | 0.467 | 0.404 | 0.327 | 0.233 |
| 9 | 0.592 | 0.424 | 0.361 | 0.284 | 0.194 |
| 10 | 0.558 | 0.386 | 0.322 | 0.247 | 0.162 |
Required:
2a. Assuming that the desired rate of return is 15%, prepare a net present value analysis for each project. Use the present value of $1 table above. If required, use the minus sign to indicate a negative net present value. If required, round to the nearest dollar.
| Branch Office Expansion | Computer System Upgrade | ATM Kiosk Expansion | |
| Present value of net cash flow total: | $ | $ | $ |
| Less amount to be invested: | $ | $ | $ |
| Net present value: | $ | $ | $ |
2b. Determine a present value index for each project. If required, round your answers to two decimal places.
| Present Value Index | |
| Branch Office Expansion | |
| Computer System Upgrade | |
| ATM Kiosk Expansion |
In: Accounting
A magazine provided overall customer satisfaction scores for AT&T, Sprint, T-Mobile, and Verizon cell-phone services in major metropolitan areas throughout the United States. The rating for each service reflects the overall customer satisfaction considering a variety of factors such as cost, connectivity problems, dropped calls, static interference, and customer support. A satisfaction scale from 0 to 100 was used with 0 indicating completely dissatisfied and 100 indicating completely satisfied. The ratings for the four cell-phone services in 20 metropolitan areas are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.
| City | AT&T | Sprint | T-Mobile | Verizon |
| Atlanta | 69 | 68 | 74 | 80 |
| Boston | 68 | 66 | 77 | 77 |
| Chicago | 70 | 67 | 73 | 78 |
| Dallas | 74 | 67 | 77 | 79 |
| Denver | 70 | 69 | 76 | 78 |
| Detroit | 72 | 67 | 80 | 80 |
| Jacksonville | 72 | 66 | 78 | 82 |
| Las Vegas | 71 | 70 | 77 | 82 |
| Los Angeles | 65 | 67 | 71 | 79 |
| Miami | 67 | 71 | 76 | 81 |
| Minneapolis | 67 | 68 | 78 | 78 |
| Philadelphia | 71 | 68 | 74 | 79 |
| Phoenix | 67 | 68 | 79 | 82 |
| San Antonio | 74 | 67 | 78 | 81 |
| San Diego | 68 | 70 | 75 | 80 |
| San Francisco | 65 | 71 | 76 | 76 |
| Seattle | 67 | 69 | 77 | 78 |
| St. Louis | 73 | 68 | 77 | 80 |
| Tampa | 72 | 65 | 76 | 80 |
| Washington | 71 | 70 | 74 | 77 |
a. Consider T-Mobile first. What is the median rating (to 1 decimal)?
b. Develop a five-number summary for the T-Mobile service.
| Smallest value | |
| First quartile (to 2 decimals) | |
| Median (to 1 decimal) | |
| Third quartile (to 2 decimals) | |
| Largest value |
c. Are there outliers for T-Mobile?
_________Yes, the data contain outliersNo, the data do not contain outliers
d. Repeat parts (b) and (c) for the other three cell-phone services.
| AT&T | Sprint | Verizon | |
| Smallest value | |||
| First quartile (to 2 decimals) | |||
| Median (to 1 decimal) | |||
| Third quartile (to 2 decimals) | |||
| Largest value |
Are there outliers for AT&T?
_________Yes, the data contain outliersNo, the data do not contain outliers
Are there outliers for Sprint?
_________Yes, the data contain outliersNo, the data do not contain outliers
Are there outliers for Verizon?
_________Yes, the data contain outliersNo, the data do not contain outliers
e. Which of the following box plots accurately displays the data set?
| #1 |
Rating |
#2 |
Rating |
| #3 |
Rating |
#4 |
Rating |
_________Box plot #1Box plot #2Box plot #3Box plot #4
Which service did the magazine recommend as being best in terms of overall customer satisfaction?
_________AT&TSprintT-MobileVerizon
In: Math