Name:
Instructor:
Accounting, Fourth Edition by Kimmel, Weygandt, and Kieso
Primer on Using Excel in Accounting by Rex A Schildhouse
Date:
Course:
P20-1A - Prepare budgeted income statement and supporting budgets.
Glendo Farm Supply Company manufactures and sells a pesticide called Snare. The following data are available for
preparing budgets for Snare for the first 2 quarters of 2013.
bags; Quarter 2
bags. Selling price is
1. Sales: Quarter 1
28,000
42,000
$60.00
per bag.
pounds of Gumm at a cost of
$4.00 per
2. Direct materials: Each bag of
4
Snare and
6
pound requires
pounds of Tarr at
$1.50
per pound.
3. Desired inventory levels:
Type of inventory
January 1
April 1
July 1
Snare (bags)
8,000
12,000
18,000
Gumm (pounds)
9,000
10,000
13,000
Tarr (pounds)
14,000
20,000
25,000
0.25
hours (15 minutes) per bag at an hourly rate of
$14.00
4. Direct labor: Direct labor time is
per hour.
15%
of sales plus
$175,000
5. Selling and administrative expenses are expected to be
per quarter.
30%
of income from operations.
6. Income taxes are expected to be
Your assistant has prepared two budgets: (1) The manufacturing overhead budget shows expected costs to be
of direct labor cost. (2) The direct materials budget for Tarr shows the cost of Tarr purchases to be
150%
$297,000
$439,500
in quarter 2.
in quarter 1 and
Instructions:
Prepare the budgeted income statement for the first 6 months and all required operating budgets by quarters. (Note:
Use variable and fixed in the selling and administrative expense budget.) Do not prepare the manufacturing
overhead budget or the direct materials budget for Tarr.
Title
Title
Title
GLENDO FARM SUPPLY COMPANY
Sales Budget
For the Six Months Ending June 30, 2012
Quarter
1
2
6 Months
Number
Number
Formula
Amount
Amount
Amount
Formula
Formula
Formula
Title
Title
Title
Title
Title
GLENDO FARM SUPPLY COMPANY
Production Budget
For the Six Months Ending June 30, 2012
Quarter
1
Amount
Amount
Formula
Amount
Formula
2
6 Months
Amount
Formula
Amount
Formula
Formula
Formula
Amount
Formula
Formula
Formula
Title
Title
Title
Title
Title
Title
Title
Title
Title
GLENDO FARM SUPPLY COMPANY
Direct Materials Budget - Gumm
For the Six Months Ending June 30, 2012
Quarter
1
Amount
Amount
Formula
Amount
Formula
Formula
Formula
Amount
Formula
2
6 Months
Amount
Amount
Amount
Amount
Formula
Formula
Amount
Amount
Formula
Formula
Formula
Formula
Formula
Formula
Amount
Amount
Formula
Formula
Units to be produced
Title
Title
Title
Title
GLENDO FARM SUPPLY COMPANY
Direct Labor Budget
For the Six Months Ending June 30, 2012
Quarter
1
Amount
Amount
Formula
Amount
Formula
2
6 Months
Amount
Amount
Amount
Amount
Formula
Formula
Amount
Amount
Formula
Formula
GLENDO FARM SUPPLY COMPANY
Selling and Administrative Expense Budget
For the Six Months Ending June 30, 2012
Quarter
1
2
6 Months
Budgeted sales in units
Amount
Amount
Formula
Title
Title
Total
Formula
Amount
Formula
Formula
Amount
Formula
Formula
Amount
Formula
GLENDO FARM SUPPLY COMPANY
Budgeted Income Statement
For the Six Months Ending June 30, 2012
6 Months
Title
Title
Title
Title
Title
Title
Title
Cost element
Direct materials
Title
Title
Title
Title
Title
Formula
Formula
Formula
Amount
Formula
Formula
Formula
Quantity
Number
Number
Number
Unit Cost
Amount
Amount
Amount
Total
Formula
Formula
Formula
Formula
Formula
qattachments_ea5aff63fe8a7874d112f7e0d96db9de56282f94.xlsx , Problem P20-1A , Page 1 of 1 Page(s), 04/09/2013 13:23:08
We can only answer your free 3 questions one at a time. You have two options to get your questions answered:... View the full answer
Related Questions
- Question 1: Explain the theoretical rationale for the NPV approach to investment appraisal and compare the strengths and weaknesses of the NPV approach to two
- Rating: Not yet rated
- Question #1: Explain why strengthening basis benefits a short hedge and hurts a long hedge. Question #2: Suppose you observe a European call option that is
- Rating:
- question needs to be explain
- Rating: Not yet rated
- question need to be explain
- Rating: Not yet rated
- Answer my question
- Rating: Not yet rated
- Question A. What is the cash conversion cycle (CCC)? Explain the cash conversion cycle (Figure 16-1) in your text, Fundamentals of Financial Management. Choose
- Rating: