ACCT 2000 Chapter : OCS 1005 HW 3
Get access
Related Documents
Related Questions
Show your work
Preparing a Comprehensive Budget
Ginnie Springs Company has been bottling and selling water since1940. The companyâs current owner would like to know how a newproduct would affect the companyâs rent income in the comingyear.
Required
Calculate Ginnie Springs net income for the new product in thecoming year by completing the operating budgets and budgeted incomestatement that follow. Assume that the selling price will remainconstant.
Sales budget
Ginnie Springs Company
Sales Budget
Forthe year Ended December 31
Quarter
1 | 2 | 3 | 4 | Year | |
Sales in Units | 40,000 | 30,000 | 50,000 | 55,000 | 175,000 |
Selling price per unit | X $1 | X ? | X ? | X ? | X ? |
Totals Sales | 40,000 | $ ? | X ? | X ? | X ? |
2. Production Budget:
Ginnie SpringsCompany
ProductionBudget
For the year Ended December31_____________
Quarter
1 | 2 | 3 | 4 | Year | |
Sales in Units | 40,000 | ? | ? | ? | ? |
Plus desired units of ending finished goods inventory* | 30,000 | ? | ? | 6000 | 6000 |
Desired total Units | 43000 | ? | ? | ? | ? |
Less desired units of ending finished goods inventory* | 4000 | ? | ? | ? | 4000 |
Total Production units | 39,000 | ? | ? | ? | ? |
*Desired units of ending finished goods inventory = 10% of nextquarterâs budgeted production needs in ounces. Desired ounces ofbeginning direct materials inventory = 20% of current quartersbudgeted production needs in ounces.
3.DirectMaterials Purchases budget
Ginnie SpringsCompany
Direct Materials PurchaseBudget
For the year Ended December31_____________
Quarter
1 | 2 | 3 | 4 | Year | |
Total production units | 39,000 | 32,000 | 50,500 | 55,500 | ? |
Ounces per unit | X 20 | X 20 | X 20 | X 20 | X 20 |
Total production needs in ounces | 780,000 | ? | ? | ? | ? |
Plus desired ounces of ending direct materials inventory* | 128,000 908,000 | ? ? | ? ? | 240,000 ? | 240,000 ? |
Less desired ounces of ending direct materials inventory* | 156,000 | ? | ? | ? | 156,000 |
Total ounces of direct material to be purchased | 752,000 | ? | ? | ? | ? |
Cost per ounce | X $0.01 | X ? | X ? | X ? | X ? |
Total cost of direct materials purchases | $7520 | ? | ? | ? | ? |
Desired ounces of ending direct material inventory =20% of nextquarters budgeted production needs in ounces.
Desired ounces of beginning direct materials inventory = 20% ofcurrent quarters budgeted production needs in ounces.
4.Directlabor budget:
Ginnie SpringsCompany
Direct LaborBudget
For the year EndedDecember 31_____________
Quarter
1 | 2 | 3 | 4 | Year | |
Total production units | 39,000 | ? | ? | ? | ? |
Direct labor hours per units | X 0.001 | X ? | X ? | X ? | X ? |
Total direct labor hours | 39.0 | ? | ? | ? | ? |
Direct labor cost per hour | X $8 | X ? | X ? | X ? | X ? |
Total direct labor cost | $312 | $ ? | $ ? | $ ? | $ ? |
5.Overheadbudget
Ginnie SpringsCompany
Overhead Budget
For the year EndedDecember 31_____________
Quarter
1 | 2 | 3 | 4 | Year | |
Variable overhead costs: | |||||
Factory supplies ($0.01) | $ 390 | $ ? | $ ? | $ ? | $ ? |
Employee benefits ($0.05) | 1,950 | ? | ? | ? | ? |
Inspection ($0.01) | 390 | ? | ? | ? | ? |
Maintenance and repairs($0.02) | 780 | ? | ? | ? | ? |
Utilities ($0.01) | 390 | ? | ? | ? | ? |
Total Variable overheadcosts | $3900 | $ ? | $ ? | $ ? | $ ? |
Total fixed overhead costs | 1416 | ? | ? | ? | ? |
Total overhead costs | $5,316 | $ ? | $ ? | $ ? | $ ? |
Note: The figures in parentheses are variable costs perunit.
6.Sellingand administrative expenses budget:
Ginnie SpringsCompany
Selling and Administrative Expenses Budget
For the year EndedDecember 31_____________
Quarter
1 | 2 | 3 | 4 | Year | |
Variable Selling and Administrative expenses | |||||
Delivery expenses ($0.01) | $ 400 | $ ? | $ ? | $ ? | $ ? |
Sales Commission ($0.02) | 800 | ? | ? | ? | ? |
Accounting ($0.01) | 400 | ? | ? | ? | ? |
Other administrative expenses($0.01) | 400 | ? | ? | ? | ? |
Total Variable selling and administrative exp. | $2,000 | $ ? | $ ? | $? | $? |
Total fixed selling and administrative exp. | 5000 | ? | ? | $? | ? |
Total selling and administrative expenses | $ 7,000 | $ ? | $ ? | $ ? | $ ? |
Note: The figures in parentheses arevariable costs per unit
7. Cost of goods manufactured budget:
Ginnie SpringsCompany
Cost of Goods Manufactured Budget
For the year EndedDecember 31_____________
Direct Material Used:
Direct Material Inventory,Beginning
Purchases
Cost of Direct materials available foruse
Less: Direct materials Inventory,ending
Cost of Direct Materialsused
Direct laborcosts:
Overhead costs:
Total manufacturing costs
Work in Process Inventory,beginning*
Less: work in process inventory,ending*
Cost of Goods Manufactured
Units produced
Manufactured cost perunit
It is the companyâs policy to have no units in process at theend of theyear.
8. Budgeted income statement
Ginnie Springs Company
Selling and Administrative Expenses Budget
For the year EndedDecember 31_____________
Sales
Cost of goods sold
Finished goods inventory beginning
Cost of goods manufactured
Cost of Goods available for sale
Less finished goods inventory, ending
Cost of good sold
Gross margin
Selling and administrative expenses
Income from operations
Income taxes expenses (30% tax rate)
Net Income
Net Present Value Method Annuity
E & T Excavation Company is planning an investment of $620,100 for a bulldozer. The bulldozer is expected to operate for 3,000 hours per year for seven years. Customers will be charged $140 per hour for bulldozer work. The bulldozer operator costs $30 per hour in wages and benefits. The bulldozer is expected to require annual maintenance costing $30,000. The bulldozer uses fuel that is expected to cost $39 per hour of bulldozer operation.
Present Value of an Annuity of $1 at Compound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 1.833 | 1.736 | 1.690 | 1.626 | 1.528 |
3 | 2.673 | 2.487 | 2.402 | 2.283 | 2.106 |
4 | 3.465 | 3.170 | 3.037 | 2.855 | 2.589 |
5 | 4.212 | 3.791 | 3.605 | 3.352 | 2.991 |
6 | 4.917 | 4.355 | 4.111 | 3.784 | 3.326 |
7 | 5.582 | 4.868 | 4.564 | 4.160 | 3.605 |
8 | 6.210 | 5.335 | 4.968 | 4.487 | 3.837 |
9 | 6.802 | 5.759 | 5.328 | 4.772 | 4.031 |
10 | 7.360 | 6.145 | 5.650 | 5.019 | 4.192 |
a. Determine the equal annual net cash flows from operating the bulldozer.
E and T Excavation Company | |||
Equal Annual Net Cash Flow | |||
Cash inflows: | |||
$ | |||
$ | |||
Cash outflows: | |||
$ | |||
X $ | |||
$ |
b. Determine the net present value of the investment, assuming that the desired rate of return is 20%. Use the present value of an annuity of $1 table above. Round to the nearest dollar. If required, use the minus sign to indicate a negative net present value.
Present value of annual net cash flows | $ |
Less amount to be invested | $ |
Net present value | $ |
c. Should E & T invest in the bulldozer, based on this analysis?
d. Determine the number of operating hours such that the present value of cash flows equals the amount to be invested. Round interim calculations and final answer to the nearest whole number.
hours
E & T Excavation Company is planning an investment of$357,800 for a bulldozer. The bulldozer is expected to operate for1,000 hours per year for seven years. Customers will be charged$140 per hour for bulldozer work. The bulldozer operator costs $26per hour in wages and benefits. The bulldozer is expected torequire annual maintenance costing $10,000. The bulldozer uses fuelthat is expected to cost $34 per hour of bulldozer operation.
Present Value of an Annuity of $1 atCompound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 1.833 | 1.736 | 1.690 | 1.626 | 1.528 |
3 | 2.673 | 2.487 | 2.402 | 2.283 | 2.106 |
4 | 3.465 | 3.170 | 3.037 | 2.855 | 2.589 |
5 | 4.212 | 3.791 | 3.605 | 3.352 | 2.991 |
6 | 4.917 | 4.355 | 4.111 | 3.784 | 3.326 |
7 | 5.582 | 4.868 | 4.564 | 4.160 | 3.605 |
8 | 6.210 | 5.335 | 4.968 | 4.487 | 3.837 |
9 | 6.802 | 5.759 | 5.328 | 4.772 | 4.031 |
10 | 7.360 | 6.145 | 5.650 | 5.019 | 4.192 |
a. Determine the equal annual net cash flowsfrom operating the bulldozer.
E and TExcavation Company | |||
Equal AnnualNet Cash Flow | |||
Cash inflows: | |||
Hours of operation | |||
Revenue per hour | X $ | ||
Revenue per year | $ | ||
Cash outflows: | |||
Hours of operation | |||
Fuel cost per hour | $ | ||
Labor cost per hour | |||
Total fuel and labor costs perhour | X $ | ||
Fuel and labor costs peryear | |||
Maintenance costs peryear | |||
Annual net cash flow | $ |
Feedback
a. Subtract the operating expenses (hourly fuel and labor costs,multiplied by the operating hours, plus the annual maintenancecosts) from the revenues (operating hours multiplied by the hourlyrevenue).
Learning Objective 3.
b. Determine the net present value of theinvestment, assuming that the desired rate of return is 10%. Usethe present value of an annuity of $1 table above. Round to thenearest dollar. If required, use the minus sign to indicate anegative net present value.
Present value of annual net cash flows | $ |
Less amount to be invested | $ |
Net present value | $ |
c. Should E & T invest in the bulldozer,based on this analysis?
No
d. Determine the number of operating hours suchthat the present value of cash flows equals the amount to beinvested. Round interim calculations and final answer to thenearest whole number.
hours
Feedback
b. Multiply the annual net cash flow by the present value of anannuity factor and subtract the amount to be invested.
c. Which is more favorable?
d. Set up an equation to solve for hours.