DataSpan, Inc., automated its plant at the start of the current year and installed a flexible manufacturing system. The company is also evaluating its suppliers and moving toward Lean Production. Many adjustment problems have been encountered, including problems relating to performance measurement. After much study, the company has decided to use the performance measures below, and it has gathered data relating to these measures for the first four months of operations.
| Month | ||||||||
| 1 | 2 | 3 | 4 | |||||
| Throughput time (days) | ? | ? | ? | ? | ||||
| Delivery cycle time (days) | ? | ? | ? | ? | ||||
| Manufacturing cycle efficiency (MCE) | ? | ? | ? | ? | ||||
| Percentage of on-time deliveries | 82 | % | 77 | % | 74 | % | 71 | % |
| Total sales (units) | 2100 | 2010 | 1907 | 1835 | ||||
Management has asked for your help in computing throughput time, delivery cycle time, and MCE. The following average times have been logged over the last four months:
| Average per Month (in days) | |||||||||
| 1 | 2 | 3 | 4 | ||||||
| Move time per unit | 0.6 | 0.3 | 0.4 | 0.4 | |||||
| Process time per unit | 2.3 | 2.2 | 2.1 | 2.0 | |||||
| Wait time per order before start of production | 20.0 | 21.9 | 26.0 | 28.0 | |||||
| Queue time per unit | 4.7 | 5.5 | 6.4 | 7.4 | |||||
| Inspection time per unit | 0.8 | 1.1 | 1.1 | 0.8 | |||||
Required:
1-a. Compute the throughput time for each month.
1-b. Compute the delivery cycle time for each month.
1-c. Compute the manufacturing cycle efficiency (MCE) for each month.
2. Evaluate the company’s performance over the last four months.
3-a. Refer to the move time, process time, and so forth, given for month 4. Assume that in month 5 the move time, process time, and so forth, are the same as in month 4, except that through the use of Lean Production the company is able to completely eliminate the queue time during production. Compute the new throughput time and MCE.
3-b. Refer to the move time, process time, and so forth, given for month 4. Assume in month 6 that the move time, process time, and so forth, are again the same as in month 4, except that the company is able to completely eliminate both the queue time during production and the inspection time. Compute the new throughput time and MCE.
In: Accounting
Complete the model and state the cash balance required to balance the balance sheet in Year 1.
| Assumptions | Year 0 | Year 1 |
| Investments growth | 5.0 | |
| Accounts payable % net income | 50.0% | |
| Long term debt increase (decrease) | 1.0 | |
| Income statement | Year 0 | Year 1 |
| Net income | 12.0 | 14.0 |
| Balance sheet | Year 0 | Year 1 |
| Cash | 12.0 | |
| Investments | 60.0 | |
| Total assets | 72.0 | |
| Accounts payable | 12.0 | |
| Long term debt | 20.0 | |
| Equity | 40.0 | |
| Total liabilities and equity | 72.0 | |
| Check | OK | |
| Cash flow statement | ||
| Net income | ||
| Increase (decrease) in accounts payable | ||
| Cash flow from operations | ||
| (Increase) decrease in investments | ||
| Cash flow from investing activities | ||
| Inc (dec) in long term debt | ||
| Cash flow from financing activities | ||
| Beginning cash | ||
| Net cash flow | ||
| Ending cash | 12 |
In: Accounting
DataSpan, Inc., automated its plant at the start of the current year and installed a flexible manufacturing system. The company is also evaluating its suppliers and moving toward Lean Production. Many adjustment problems have been encountered, including problems relating to performance measurement. After much study, the company has decided to use the performance measures below, and it has gathered data relating to these measures for the first four months of operations.
| Month | ||||||||
| 1 | 2 | 3 | 4 | |||||
| Throughput time (days) | ? | ? | ? | ? | ||||
| Delivery cycle time (days) | ? | ? | ? | ? | ||||
| Manufacturing cycle efficiency (MCE) | ? | ? | ? | ? | ||||
| Percentage of on-time deliveries | 91 | % | 86 | % | 82 | % | 78 | % |
| Total sales (units) | 3030 | 2900 | 2752 | 2649 | ||||
Management has asked for your help in computing throughput time, delivery cycle time, and MCE. The following average times have been logged over the last four months:
| Average per Month (in days) | |||||||||
| 1 | 2 | 3 | 4 | ||||||
| Move time per unit | 0.9 | 0.7 | 0.9 | 0.9 | |||||
| Process time per unit | 2.9 | 2.8 | 2.7 | 2.6 | |||||
| Wait time per order before start of production | 19.0 | 20.8 | 23.0 | 24.8 | |||||
| Queue time per unit | 4.4 | 5.1 | 5.9 | 6.8 | |||||
| Inspection time per unit | 0.7 | 0.9 | 0.9 | 0.7 | |||||
Required:
1-a. Compute the throughput time for each month.
1-b. Compute the delivery cycle time for each month.
1-c. Compute the manufacturing cycle efficiency (MCE) for each month.
2. Evaluate the company’s performance over the last four months.
3-a. Refer to the move time, process time, and so forth, given for month 4. Assume that in month 5 the move time, process time, and so forth, are the same as in month 4, except that through the use of Lean Production the company is able to completely eliminate the queue time during production. Compute the new throughput time and MCE.
3-b. Refer to the move time, process time, and so forth, given for month 4. Assume in month 6 that the move time, process time, and so forth, are again the same as in month 4, except that the company is able to completely eliminate both the queue time during production and the inspection time. Compute the new throughput time and MCE.
In: Accounting
A project requires $178,077 of equipment that is classified as 7-year property. What is the book value of this asset at the end of year 5 given the following MACRS depreciation allowances, starting with year one: 14.29, 24.49, 17.49, 12.49, 8.93, 8.92, 8.93, and 4.46 percent?
Enter your answer rounded off to two decimal points.
In: Accounting
A 15-year-old white female with a history of asthma since early childhood.
He diagnosis with asthma and Contraception initiation
Question
1. Diagnosis asthma
a. Explain the Pathophysiology of asthma
b. What is the therapeutic regimen of asthma?
c. What labs can you order for this patient?give the definition and Description of the Test. At least 2 labs
d. Significance of the Test Being Ordered for this Patient
E. What medication would give to this patient et why?
In: Nursing
The records of Alaska Company provide the following information for the year ended December 31
at coast at Retail
January 1 beginning inventory $ 472,950 $ 928,750
Cost of goods purchased 2,843,512 6,280,950
Sales 5,511,700
Sales returns 46,200
Required:
1. Use the retail inventory method to estimate the company’s
year-end inventory at cost.
2. A year-end physical inventory at retail prices yields a total
inventory of $1,691,800. Prepare a calculation showing the
company’s loss from shrinkage at cost and at retail.
Complete this questions by entering your answers in the tabs below.
Required 1
Required 2
Use the retail inventory method to estimate the company’s year-end inventory at cost. (Round your ratio calculations to 2 decimal places. (i.e. 10.15%))
At Cost Cost-to-Retail Ratio At Retail
Beginning inventory $472,950 $928,750
Cost of goods purchased 2,843,512 6,280,950
Cost of goods available for sale $3,316,462 $7,209,700
Net sales at retail
Complete this questions by entering your answers in the tabs below
Use the retail inventory method to estimate the company’s year-end inventory at cost. (Round your ratio calculations to 2 decimal places. (i.e. 10.15%))
|
|||||||||||||||||||||||||
A year-end physical inventory at retail prices yields a total inventory of $1,691,800. Prepare a calculation showing the company’s loss from shrinkage at cost and at retail. (Round your ratio calculations to 2 decimal places. (i.e. 10.15%))
|
||||||||||||||||||||||
In: Accounting
You are an audit consultant at a top tier accounting firm that is celebrating another year of fee income growth from one of its most important audit clients, a huge telecommunications business (think Telstra / Vodaphone). The last audit you did for this client had run smoothly from your company’s point of view, despite some hiccups on delivery times and quality control, but overall, your accounting firm were happy with the depth of this client relationship and its position to keep their business (future tax and consulting projects to the accounting firm of around $1.6 million).
However, yesterday, the telecommunications client asked for an internal review of your account service to negotiate a revised audit fee for the following three years. This leaves you and your accounting colleagues mystified as to why they want to do this.
The client spoke to you yesterday, requesting a meeting to discuss and have stated that they were generally happy with the relationship but asked that the lead audit partner from your firm be removed from the team and they also want to lower the total audit fee by 15%. This will have a negative impact of $185,000 on the accountants.
Instructions (in pairs):
In: Accounting
In October of the current year, Jasmine received a $15,520 payment from a client for 32 months of rent. The rental period begins on September 1 of this year. This amounts to $485 per month. Jasmine is a calendar-year taxpayer.
What amount of the $15,520 payment, if any, must Jasmine recognize this year if she uses the accrual method of accounting?
Numeric Response ?
In: Accounting
Northern Illinois Manufacturing is preparing its budget for the coming year. The first step is to plan for the first quarter of that coming year. Northern Illinois gathered the following information from its managers.
Sales:
|
Actual unit sates for November |
113,500 |
|
Actual unit sales for December |
103,100 |
|
Expected unit sales for January |
114,000 |
|
Expected unit sales for February |
113,500 |
|
Expected unit sales for March |
116,000 |
|
Expected unit sales for April |
126,000 |
|
Expected unit sales for May |
138,500 |
|
Unit selling price |
$12 |
Northern Illinois wants to keep 10% of the next month’s unit sales in ending inventory. All sales are on account. 85% of the Accounts Receivable are collected in the month of sale and 15% of the Accounts Receivable are collected in the month after sale. Accounts receivable on December 31 totaled 183,780.
Direct Materials:
The product uses metal, plastic, and rubber. In total, each unit requires 2 pounds of material at an average cost of 0.75 per pound.
Northern Illinois likes to keep 5% of the materials needed for the next month in its ending inventory. Payment for materials is made within 15 days. 50% is paid in the month of purchase and 50% is paid in the month after purchase. Accounts Payable on December 31 totaled $120,595. Raw materials on December 31 totaled 11,295 pounds.
Direct Labor:
Labor requires 12 minutes per unit for completion and is paid at a rate of $18 per hour.
Manufacturing Overhead:
|
Indirect materials |
30 cents per labor hour |
|
Indirect labor |
50 cents per labor hour |
|
Utilities |
45 cents per labor hour |
|
Maintenance |
25 cents per labor hour |
|
Salaries |
$52,000 per month |
|
Depreciation |
$16,800 per month |
|
Property taxes |
$2,675 per month |
|
Insurance |
$2,200 per month |
|
Janitorial |
$1,800 per month |
Selling and Administrative Expenses:
Variable selling and administrative cost per unit is $2.40.
Fixed selling and administrative costs per month are:
|
Advertising |
$15,000 per month |
|
Insurance |
$1,400 per month |
|
Salaries |
$72,000 per month |
|
Depreciation |
$2,500 per month |
|
Other fixed costs |
$3,000 per month |
Other Information:
The cash balance on December 31 totaled $220,500, but management has decided that it wants to maintain a cash balance of at least $750,000 beginning January 31. Dividends are paid each month at the rate of $2.50 per share for 5,000 shares outstanding. The company has an open line of credit with the First National Bank. The terms of the agreement requires borrowing to be in $1,000 increments at 8% interest. Northern Illinois borrows on the first day of the month and repays on the last day of the month. Reserve repayment, if required, until Northern Illinois can pay the entire amount. A $250,000 equipment purchase is planned for February.
Instructions (Do all parts):
Note: All budgets and schedules should be prepared by month for the first quarter (January, February, and March). Round all figures to the nearest dollar. For labor hours round to whole hours.
e. Prepare a manufacturing overhead budget.
f. Prepare a selling and administrative budget.
g. Prepare a schedule for expected cash collections from customers.
h. Prepare a schedule for expected payments for materials purchases.
i. Prepare a cash budget.
In: Accounting
The net income reported on the income statement for the current year was $318,700. Depreciation recorded on equipment and a building amounted to $93,980 for the year. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows:
| End of Year | Beginning of Year | |
|---|---|---|
| Cash | $90,370 | $95,280 |
| Accounts receivable (net) | 111,660 | 118,570 |
| Inventories | 232,780 | 203,250 |
| Prepaid expenses | 12,000 | 15,310 |
| Accounts payable (merchandise creditors) | 96,420 | 104,940 |
| Salaries payable | 15,310 | 13,420 |
Required:
| A. | Prepare the Cash Flows from Operating Activities section of the statement of cash flows, using the indirect method. Refer to the Amount Descriptions list provided for the exact wording of the answer choices for text entries. Use the minus sign to indicate cash outflows, cash payments, decreases in cash and for any adjustments, if required. |
| B. | If the direct method had been used, would the net cash flow from operating activities have been the same? |
In: Accounting