ACCT 2203 Lecture Notes - Lecture 6: Budget, Indian Railways, Fixed Cost
Document Summary
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
Litres: | ||
Beginning work in process inventory | 2,800 | litres |
Started production | 4,620 | litres |
Completed and transferred out to Packagingin March | 6,420 | litres |
Ending work in process inventory (80% ofthe way through | ||
the fermenting process) | 1,000 | litres |
Costs: | ||
Beginning work in process inventory($2,200 of direct | ||
materials and $1,462 of conversioncost) | $3,662 | |
Costs added during March: | ||
Direct materials | 10,414 | |
Direct labour | 950 | |
Manufacturing overhead | 1,920 | |
Total costs added during March | $13,284 |
1. | Fill in the time line for the Fermenting Department. |
2. | Summarize the flow of physical units and compute the totalequivalent units. |
3. | Summarize total costs to account for and compute the cost perequivalent unit for direct materials and conversion costs. |
4. | Assign total costs to units​ (litres): |
a. Completed and transferred out to thePackaging Department b. In the Fermenting Department ending work inprocess inventory | |
5. | Whatis the average cost per litre transferred out of Fermenting into​packaging? Why would JohnsonJohnson ​Vineyard's managers want toknow this​ cost? |
Requirement 1. Fill in the time line for the FermentingDepartment.
Start |
| Complete | Complete | |||||||||
Transferred out to Packaging | ||||||||||||
Requirement 2. Summarize the flow of physical units and computethe total equivalent units.
Johnson Vineyards | |||
Fermenting Department | |||
Flow of Physical Units and Computation of Equivalent Units | |||
Flow of | Equivalent Units | ||
Physical | Direct | Conversion | |
Flow of Production | Units | Materials | Costs |
Units to account for: | |||
Units accounted for: | |||
Total equivalent units |
Requirement 3. Summarize total costs to account for and computethe cost per equivalent unit for direct materials and conversioncosts. ​(Round the cost per equivalent unit to the nearest​cent.)
Johnson Vineyards | |||
Fermenting Department | |||
Cost per Equivalent Unit | |||
Direct | Conversion | ||
Materials | Costs | Total | |
Cost per equivalent unit |
Requirement 4. Assign total costs to units​ (litres):
Now we can calculate the total cost of the units for a.completed and transferred out to the Packaging Department and b.the Fermenting Department ending work in process. ​(Enterquantities​ first, then the cost per equivalent unit amounts in thesame order as calculated in the preceding step. Round your answersto the nearest​ cent.)
Johnson Vineyards | |||||||||
Fermenting Department | |||||||||
Assignment of Costs | |||||||||
Assign costs: | Direct Materials | Conversion Costs | Total | ||||||
a. | x ( | + | ) | ||||||
b. | |||||||||
x | |||||||||
x | |||||||||
Total cost accounted for |
Requirement 5. What is the average cost per litre transferredout of Fermenting into​ Packaging? Why would Johnson ​Vineyard'smanagers want to know this​ cost?
First identify the labels to compute the average cost per litretransferred​ out, then compute the average cost per unit. ​(Roundyour answer to the nearest​ cent.)
Avg. cost | ||||
/ | = | per litre |
/ | = |
Why would Johnson ​Vineyard's managers want to know this​cost?
Managers will want to know this cost to compare it to their.................budgeted target costs cost per equivalent unitdirect material costs . They may also use the cost information when..................
.