Month of March, 2019:
Total deliveries made 278
Shipments delivered late 16
Transit time for 12 sample shipments 3, 3, 5, 4, 6, 5, 6, 4, 6, 7, 5, 4
Total units ordered 865,000
Total units shipped 830,400
Total units lost or damaged 4,800
March 31 inventory level $849,000
March monthly sales $2,575,000
|
Transportation Performance Analysis |
||||||
|
What percentage of shipments were delivered on time in March 2019? |
||||||
|
What was the average transit time across the sample of 12 deliveries?
|
1. Total deliveries on time = 278- late deliveries = 278-16 = 262
%age of on time deliveries = 262/278 = 94.245
2. Average transit time = (3+3+5+4+6+5+6+4+6+7+5+4) / 12 = 4.83
3. Fill rate = Units Shipped / Units ordered = 830400 / 865000 = 96%
4. Unit damage rate = Damaged units / Units shipped = 4800 / 830400 =0.58%
5. Inventory turnover = March monthly sales / Inventory = $2,575,000 / $849,000 = 3.03
6. Days of inventory at hand = Number of days in March / Inventory turnover ratio = 31 / 3.03 = 10.23 days
Alternatively, daily sales =$2,575,000/31= 83064.52
Days of inventory at hand = Inventory / Daily sales = $849,000/ 83064.52 = 10.23 days
The management of Zigby Manufacturing prepared the following
estimated balance sheet for March 2019.
To prepare a master budget for April, May, and June of 2019,
management gathers the following information.
Sales for March total 20,000 units. Forecasted sales in units
are as follows: April, 20,000; May, 19,000; June, 19,500; and July,
20,000. Sales of 245,000 units are forecasted for the entire year.
The product’s selling price is $26.00 per unit and its total
product cost is $22.80 per unit....
QUESTION 24 MONTH January February March April UNITS SOLD TOTAL COSTS 980 $3,500 780 $4,000 1,080 $5,500 1,280 $5,000 Estimate variable costs per unit using the information above. Estimate fixed costs using the information above. QUESTION 16 Estimate unit variable costs and fixed costs using the following information. Month Total Costs Sales Volume (units) March $180 April $190 May $260 June $280 O A. Unit VC = $6/FC = $84 OB. Unit VC = $8/FC = $52 C. Unit VC...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity 65,000 437,760 90, 200 308, 028 900,988 630,000 (165,000) 465,000 $...
Слеск The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $ 50,000 434,240 84,210 368,000 936,450 602,000 (151,000) 451,000 $1,387,450...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash $ 80,000 Accounts receivable 364,000 Raw materials inventory 96,000 Finished goods inventory 364,800 Total current assets 904,800 Equipment 610,000 Accumulated depreciation (155,000 ) Equipment, net 455,000 Total assets $ 1,359,800 Liabilities and Equity Accounts payable $ 195,500 Short-term notes payable 17,000 Total current liabilities 212,500 Long-term note payable 510,000 Total liabilities 722,500 Common stock 340,000 Retained...
The management of Zigby Manufacturing prepared the following
estimated balance sheet for March 2019.
To prepare a master budget for April, May, and June of 2019,
management gathers the following information.
Sales for March total 20,000 units. Forecasted sales in units
are as follows: April, 20,000; May, 19,000; June, 19,500; and July,
20,000. Sales of 245,000 units are forecasted for the entire year.
The product’s selling price is $26.00 per unit and its total
product cost is $22.80 per unit....
The management of Zigby Manufacturing prepared the following
estimated balance sheet for March 2019
Sales for March total 20,000 units. Forecasted sales in units
are as follows: April, 20,000; May, 19,000; June, 19,500; and July,
20,000. Sales of 245,000 units are forecasted for the entire year.
The product’s selling price is $26.00 per unit and its total
product cost is $22.80 per unit.
Company policy calls for a given month’s ending raw materials
inventory to equal 50% of the next...
10
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $ 65,000 437, 760 90, 200 308,828 900,988 630, eee...
The management of Zigby Manufacturing prepared the following
estimated balance sheet for March 2019.
ZIGBY MANUFACTURING
Estimated Balance Sheet
March 31, 2019
Assets
Cash
$
42,000
Accounts receivable
364,000
Raw materials inventory
107,200
Finished goods inventory
349,440
Total current assets
862,640
Equipment
604,000
Accumulated depreciation
(152,000
)
Equipment, net
452,000
Total assets
$
1,314,640
Liabilities and Equity
Accounts payable
$
211,300
Short-term notes payable
14,000
Total current liabilities
225,300
Long-term note payable
510,000
Total liabilities
735,300
Common stock
337,000
Retained...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $ 44,000 500,000 90,200 444,000 1,078, 200 608,000 (154,000) 454,000 $1,532,200...