Sales, Production, Direct Materials Purchases, and Direct Labor Cost Budgets
The budget director of Gourmet Grill Company requests estimates of sales, production, and other operating data from the various administrative units every month. Selected information concerning sales and production for July is summarized as follows:
a. Estimated sales for July by sales territory:
Maine: | |
Backyard Chef | 310 units at $700 per unit |
Master Chef | 150 units at $1,200 per unit |
Vermont: | |
Backyard Chef | 240 units at $750 per unit |
Master Chef | 110 units at $1,300 per unit |
New Hampshire: | |
Backyard Chef | 360 units at $750 per unit |
Master Chef | 180 units at $1,400 per unit |
b. Estimated inventories at July 1:
Direct materials: | |
Grates | 290 units |
Stainless steel | 1,500 lbs. |
Burner subassemblies | 170 units |
Shelves | 340 units |
Finished products: | |
Backyard Chef | 30 units |
Master Chef | 32 units |
c. Desired inventories at July 31:
Direct materials: | |
Grates | 340 units |
Stainless steel | 1,800 lbs. |
Burner subassemblies | 155 units |
Shelves | 315 units |
Finished products: | |
Backyard Chef | 40 units |
Master Chef | 22 units |
d. Direct materials used in production:
In manufacture of Backyard Chef: | |
Grates | 3 units per unit of product |
Stainless steel | 24 lbs. per unit of product |
Burner subassemblies | 2 units per unit of product |
Shelves | 4 units per unit of product |
In manufacture of Master Chef: | |
Grates | 6 units per unit of product |
Stainless steel | 42 lbs. per unit of product |
Burner subassemblies | 4 units per unit of product |
Shelves | 5 units per unit of product |
e. Anticipated purchase price for direct materials:
Grates | $15 per unit |
Stainless steel | $6 per lb. |
Burner subassemblies | $110 per unit |
Shelves | $10 per unit |
f. Direct labor requirements:
Backyard Chef: | |
Stamping Department | 0.50 hr. at $17 per hr. |
Forming Department | 0.60 hr. at $15 per hr. |
Assembly Department | 1.00 hr. at $14 per hr. |
Master Chef: | |
Stamping Department | 0.60 hr. at $17 per hr. |
Forming Department | 0.80 hr. at $15 per hr. |
Assembly Department | 1.50 hrs. at $14 per hr. |
Required:
1. Prepare a sales budget for July.
Gourmet Grill Company Sales Budget For the Month Ending July 31 |
||||
---|---|---|---|---|
Product and Area | Unit Sales Volume |
Unit Selling Price |
Total Sales | |
Backyard Chef: | ||||
Maine | $ | $ | ||
Vermont | ||||
New Hampshire | ||||
Total | $ | |||
Master Chef: | ||||
Maine | $ | $ | ||
Vermont | ||||
New Hampshire | ||||
Total | $ | |||
Total revenue from sales | $ |
2. Prepare a production budget for July. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Gourmet Grill Company Production Budget For the Month Ending July 31 |
||
---|---|---|
Units | ||
Backyard Chef | Master Chef | |
3. Prepare a direct materials purchases budget for July. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Gourmet Grill Company Direct Materials Purchases Budget For the Month Ending July 31 |
|||||
---|---|---|---|---|---|
Grates (units) |
Stainless Steel (lbs.) |
Burner Sub- assemblies (units) |
Shelves (units) |
Total | |
Required units for production: | |||||
Backyard Chef | |||||
Master Chef | |||||
Desired inventory, July 31 | |||||
Total | |||||
Estimated inventory, July 1 | |||||
Total units to be purchased | |||||
Unit price | $ | $ | $ | $ | |
Total direct materials to be purchased | $ | $ | $ | $ | $ |
4. Prepare a direct labor cost budget for July.
Gourmet Grill Company Direct Labor Cost Budget For the Month Ending July 31 |
||||||||
---|---|---|---|---|---|---|---|---|
Stamping Department |
Forming Department | Assembly Department | Total | |||||
Hours required for production: | ||||||||
Backyard Chef | ||||||||
Master Chef | ||||||||
Total | ||||||||
Hourly rate | $ | $ | $ | |||||
Total direct labor cost | $ | $ | $ | $ |
In: Accounting
Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout Southeast Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company’s products. The company now is planning raw materials needs for the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements:
The finished goods inventory on hand at the end of each month must equal 4,000 units of Supermix plus 20% of the next month’s sales. The finished goods inventory on June 30 is budgeted to be 19,000 units.
The raw materials inventory on hand at the end of each month must equal one-half of the following month’s production needs for raw materials. The raw materials inventory on June 30 is budgeted to be 114,000 cc of solvent H300.
The company maintains no work in process inventories.
A monthly sales budget for Supermix for the third and fourth quarters of the year follows.
Budgeted Unit Sales | |
July | 75,000 |
August | 80,000 |
September | 90,000 |
October | 70,000 |
November | 60,000 |
December | 50,000 |
Required:
1. Prepare a production budget for Supermix for the months July, August, September, and October.
3. Prepare a direct materials budget showing the quantity of solvent H300 to be purchased for July, August, and September, and for the quarter in total.
In: Accounting
A company bought the available for sale investments during 2017 (no investments as of 12/31/16)
- they bought 200 shares of apple stock for $40,000 on 2/1/17
- they bought 100 treasury bonds at $1,000 par each with an 4% interest rate at 4/2/2017 (semi annual on 4/1 and 10/1)
- $50,000 of company B 9% bonds due 3/1/37, interest payable on 3/1. our company paid 50,000 plus accrued interest for these bonds on 7/1/17
Required:
1- prepare journal entries for 2017 for all purchases on the investments
2- prepare all the appropriate adjusting entries as of 12/31/17 for the investments, Fair Market Value as of 12/31/17
Company A C-Stock $42,000
Treasury bonds $104,000
Company B Bonds $51,000
3- The Treasury bonds were sold on 7/1/18 for $103,000 plus accrued interest . prepare the journal entry.
In: Accounting
Provide at least three reasons why companies are hesitant to adopt the intranet and for each reason describe how the company can best manage these issues
In: Accounting
Required information Exercise 8-18 Complete the accounting cycle (LO8-1, 8-2, 8-4, 8-6) On January 1, 2021, the general ledger of ACME Fireworks includes the following account balances: Accounts Debit Credit Cash $ 25,100 Accounts Receivable 46,200 Allowance for Uncollectible Accounts $ 4,200 Inventory 20,000 Land 46,000 Equipment 15,000 Accumulated Depreciation 1,500 Accounts Payable 28,500 Notes Payable (6%, due April 1, 2022) 50,000 Common Stock 35,000 Retained Earnings 33,100 Totals $ 152,300 $ 152,300 During January 2021, the following transactions occur: January 2 Sold gift cards totaling $8,000. The cards are redeemable for merchandise within one year of the purchase date. January 6 Purchase additional inventory on account, $147,000. January 15 Firework sales for the first half of the month total $135,000. All of these sales are on account. The cost of the units sold is $73,800. January 23 Receive $125,400 from customers on accounts receivable. January 25 Pay $90,000 to inventory suppliers on accounts payable. January 28 Write off accounts receivable as uncollectible, $4,800. January 30 Firework sales for the second half of the month total $143,000. Sales include $11,000 for cash and $132,000 on account. The cost of the units sold is $79,500. January 31 Pay cash for monthly salaries, $52,000. Exercise 8-18 Part 1 1. Record each of the transactions listed above. (If no entry is required for a particular transaction/event, select "No Journal Entry Required" in the first account field.)
In: Accounting
Solving for Unknowns
Misterio Company uses a standard costing system. During the past quarter, the following variances were computed:
Variable overhead efficiency variance | $ 24,000 U |
Direct labor efficiency variance | 120,000 U |
Direct labor rate variance | 10,400 U |
Misterio applies variable overhead using a standard rate of $2 per direct labor hour allowed. Two direct labor hours are allowed per unit produced. (Only one type of product is manufactured.) During the quarter, Misterio used 30 percent more direct labor hours than should have been used.
Required:
1. What were the actual direct labor hours
worked?
hours
What are the total hours allowed?
hours
2. What is the standard hourly rate for direct
labor?
$ per hour
What is the actual hourly rate? Round your answer to the nearest
cent.
$ per hour
3. How many actual units were produced?
units
In: Accounting
Garver Industries has budgeted the following unit sales:
2017 | Units | ||
January | 10,000 | ||
February | 8,000 | ||
March | 9,000 | ||
April | 11,000 | ||
May | 15,000 |
The finished goods units on hand on December 31, 2016, was 2,000
units. Each unit requires 3 pounds of raw materials that are
estimated to cost an average of $4 per pound. It is the company's
policy to maintain a finished goods inventory at the end of each
month equal to 20% of next month's anticipated sales. They also
have a policy of maintaining a raw materials inventory at the end
of each month equal to 30% of the pounds needed for the following
month's production. There were 8,640 pounds of raw materials on
hand at December 31, 2016.
For the first quarter of 2017, prepare a production budget.
GARVER INDUSTRIES Production Budget For the Quarter Ended March 31, 2017 |
||||||||||
January | February | March | Total | |||||||
Desired ending finished goods unitsExpected unit salesRequired production unitsTotal required unitsBeginning finished goods unitsCost per poundDirect materials purchases | ||||||||||
Direct materials purchasesCost per poundDesired ending finished goods unitsExpected unit salesRequired production unitsTotal required unitsBeginning finished goods units | ||||||||||
Cost per poundDirect materials purchasesExpected unit salesTotal required unitsRequired production unitsBeginning finished goods unitsDesired ending finished goods units | ||||||||||
AddLess: | Direct materials purchasesExpected unit salesRequired production unitsCost per poundBeginning finished goods unitsTotal required unitsDesired ending finished goods units | |||||||||
Cost per poundTotal required unitsExpected unit salesBeginning finished goods unitsDirect materials purchasesDesired ending finished goods unitsRequired production units |
For the first quarter of 2017, prepare a direct materials budget.
GARVER INDUSTRIES Direct Materials Budget For the Quarter Ended March 31, 2017 |
||||||||||
January | February | March | Total | |||||||
Direct materials purchasesTotal cost of direct materials purchasesTotal pounds needed for productionDirect materials per unitBeginning direct materialsDesired ending direct materialsCost per poundTotal materials requiredUnits to be produced | $ | $ | $ | |||||||
Total pounds needed for productionDirect materials purchasesDirect materials per unitUnits to be producedTotal cost of direct materials purchasesTotal materials requiredDesired ending direct materialsBeginning direct materialsCost per pound | ||||||||||
Cost per poundUnits to be producedDesired ending direct materialsDirect materials purchasesTotal pounds needed for productionBeginning direct materialsDirect materials per unitTotal materials requiredTotal cost of direct materials purchases | ||||||||||
Total materials requiredCost per poundUnits to be producedDirect materials purchasesTotal cost of direct materials purchasesTotal pounds needed for productionDesired ending direct materialsDirect materials per unitBeginning direct materials | ||||||||||
Direct materials purchasesCost per poundTotal materials requiredDirect materials per unitDesired ending direct materialsBeginning direct materialsTotal pounds needed for productionTotal cost of direct materials purchasesUnits to be produced | ||||||||||
AddLess: | Direct materials per unitTotal pounds needed for productionTotal cost of direct materials purchasesBeginning direct materialsTotal materials requiredUnits to be producedCost per poundDirect materials purchasesDesired ending direct materials | |||||||||
Units to be producedDirect materials purchasesDirect materials per unitTotal pounds needed for productionTotal materials requiredDesired ending direct materialsTotal cost of direct materials purchasesCost per poundBeginning direct materials | ||||||||||
Desired ending direct materialsDirect materials per unitDirect materials purchasesCost per poundTotal materials requiredUnits to be producedTotal cost of direct materials purchasesBeginning direct materialsTotal pounds needed for production | ||||||||||
Total cost of direct materials purchasesDirect materials per unitUnits to be producedTotal pounds needed for productionDesired ending direct materialsBeginning direct materialsDirect materials purchasesCost per poundTotal materials required | $ | $ | $ | $ |
Attempts: 0 of 1 used
Save for LaterCheck Answer
Send to Gradebook
Prev
In: Accounting
Garver Industries has budgeted the following unit sales:
2017 | Units | ||
January | 10,000 | ||
February | 8,000 | ||
March | 9,000 | ||
April | 11,000 | ||
May | 15,000 |
The finished goods units on hand on December 31, 2016, was 2,000
units. Each unit requires 3 pounds of raw materials that are
estimated to cost an average of $4 per pound. It is the company's
policy to maintain a finished goods inventory at the end of each
month equal to 20% of next month's anticipated sales. They also
have a policy of maintaining a raw materials inventory at the end
of each month equal to 30% of the pounds needed for the following
month's production. There were 8,640 pounds of raw materials on
hand at December 31, 2016.
For the first quarter of 2017, prepare a production budget.
GARVER INDUSTRIES Production Budget For the Quarter Ended March 31, 2017 |
||||||||||
January | February | March | Total | |||||||
Desired ending finished goods unitsExpected unit salesRequired production unitsTotal required unitsBeginning finished goods unitsCost per poundDirect materials purchases | ||||||||||
Direct materials purchasesCost per poundDesired ending finished goods unitsExpected unit salesRequired production unitsTotal required unitsBeginning finished goods units | ||||||||||
Cost per poundDirect materials purchasesExpected unit salesTotal required unitsRequired production unitsBeginning finished goods unitsDesired ending finished goods units | ||||||||||
AddLess: | Direct materials purchasesExpected unit salesRequired production unitsCost per poundBeginning finished goods unitsTotal required unitsDesired ending finished goods units | |||||||||
Cost per poundTotal required unitsExpected unit salesBeginning finished goods unitsDirect materials purchasesDesired ending finished goods unitsRequired production units |
For the first quarter of 2017, prepare a direct materials budget.
GARVER INDUSTRIES Direct Materials Budget For the Quarter Ended March 31, 2017 |
||||||||||
January | February | March | Total | |||||||
Direct materials purchasesTotal cost of direct materials purchasesTotal pounds needed for productionDirect materials per unitBeginning direct materialsDesired ending direct materialsCost per poundTotal materials requiredUnits to be produced | $ | $ | $ | |||||||
Total pounds needed for productionDirect materials purchasesDirect materials per unitUnits to be producedTotal cost of direct materials purchasesTotal materials requiredDesired ending direct materialsBeginning direct materialsCost per pound | ||||||||||
Cost per poundUnits to be producedDesired ending direct materialsDirect materials purchasesTotal pounds needed for productionBeginning direct materialsDirect materials per unitTotal materials requiredTotal cost of direct materials purchases | ||||||||||
Total materials requiredCost per poundUnits to be producedDirect materials purchasesTotal cost of direct materials purchasesTotal pounds needed for productionDesired ending direct materialsDirect materials per unitBeginning direct materials | ||||||||||
Direct materials purchasesCost per poundTotal materials requiredDirect materials per unitDesired ending direct materialsBeginning direct materialsTotal pounds needed for productionTotal cost of direct materials purchasesUnits to be produced | ||||||||||
AddLess: | Direct materials per unitTotal pounds needed for productionTotal cost of direct materials purchasesBeginning direct materialsTotal materials requiredUnits to be producedCost per poundDirect materials purchasesDesired ending direct materials | |||||||||
Units to be producedDirect materials purchasesDirect materials per unitTotal pounds needed for productionTotal materials requiredDesired ending direct materialsTotal cost of direct materials purchasesCost per poundBeginning direct materials | ||||||||||
Desired ending direct materialsDirect materials per unitDirect materials purchasesCost per poundTotal materials requiredUnits to be producedTotal cost of direct materials purchasesBeginning direct materialsTotal pounds needed for production | ||||||||||
Total cost of direct materials purchasesDirect materials per unitUnits to be producedTotal pounds needed for productionDesired ending direct materialsBeginning direct materialsDirect materials purchasesCost per poundTotal materials required | $ | $ | $ | $ |
Attempts: 0 of 1 used
Save for LaterCheck Answer
Send to Gradebook
Prev
In: Accounting
Garver Industries has budgeted the following unit sales:
2017 | Units | ||
January | 10,000 | ||
February | 8,000 | ||
March | 9,000 | ||
April | 11,000 | ||
May | 15,000 |
The finished goods units on hand on December 31, 2016, was 2,000
units. Each unit requires 3 pounds of raw materials that are
estimated to cost an average of $4 per pound. It is the company's
policy to maintain a finished goods inventory at the end of each
month equal to 20% of next month's anticipated sales. They also
have a policy of maintaining a raw materials inventory at the end
of each month equal to 30% of the pounds needed for the following
month's production. There were 8,640 pounds of raw materials on
hand at December 31, 2016.
For the first quarter of 2017, prepare a production budget.
GARVER INDUSTRIES Production Budget For the Quarter Ended March 31, 2017 |
||||||||||
January | February | March | Total | |||||||
Desired ending finished goods unitsExpected unit salesRequired production unitsTotal required unitsBeginning finished goods unitsCost per poundDirect materials purchases | ||||||||||
Direct materials purchasesCost per poundDesired ending finished goods unitsExpected unit salesRequired production unitsTotal required unitsBeginning finished goods units | ||||||||||
Cost per poundDirect materials purchasesExpected unit salesTotal required unitsRequired production unitsBeginning finished goods unitsDesired ending finished goods units | ||||||||||
AddLess: | Direct materials purchasesExpected unit salesRequired production unitsCost per poundBeginning finished goods unitsTotal required unitsDesired ending finished goods units | |||||||||
Cost per poundTotal required unitsExpected unit salesBeginning finished goods unitsDirect materials purchasesDesired ending finished goods unitsRequired production units |
For the first quarter of 2017, prepare a direct materials budget.
GARVER INDUSTRIES Direct Materials Budget For the Quarter Ended March 31, 2017 |
||||||||||
January | February | March | Total | |||||||
Direct materials purchasesTotal cost of direct materials purchasesTotal pounds needed for productionDirect materials per unitBeginning direct materialsDesired ending direct materialsCost per poundTotal materials requiredUnits to be produced | $ | $ | $ | |||||||
Total pounds needed for productionDirect materials purchasesDirect materials per unitUnits to be producedTotal cost of direct materials purchasesTotal materials requiredDesired ending direct materialsBeginning direct materialsCost per pound | ||||||||||
Cost per poundUnits to be producedDesired ending direct materialsDirect materials purchasesTotal pounds needed for productionBeginning direct materialsDirect materials per unitTotal materials requiredTotal cost of direct materials purchases | ||||||||||
Total materials requiredCost per poundUnits to be producedDirect materials purchasesTotal cost of direct materials purchasesTotal pounds needed for productionDesired ending direct materialsDirect materials per unitBeginning direct materials | ||||||||||
Direct materials purchasesCost per poundTotal materials requiredDirect materials per unitDesired ending direct materialsBeginning direct materialsTotal pounds needed for productionTotal cost of direct materials purchasesUnits to be produced | ||||||||||
AddLess: | Direct materials per unitTotal pounds needed for productionTotal cost of direct materials purchasesBeginning direct materialsTotal materials requiredUnits to be producedCost per poundDirect materials purchasesDesired ending direct materials | |||||||||
Units to be producedDirect materials purchasesDirect materials per unitTotal pounds needed for productionTotal materials requiredDesired ending direct materialsTotal cost of direct materials purchasesCost per poundBeginning direct materials | ||||||||||
Desired ending direct materialsDirect materials per unitDirect materials purchasesCost per poundTotal materials requiredUnits to be producedTotal cost of direct materials purchasesBeginning direct materialsTotal pounds needed for production | ||||||||||
Total cost of direct materials purchasesDirect materials per unitUnits to be producedTotal pounds needed for productionDesired ending direct materialsBeginning direct materialsDirect materials purchasesCost per poundTotal materials required | $ | $ | $ | $ |
Attempts: 0 of 1 used
Save for LaterCheck Answer
Send to Gradebook
Prev
In: Accounting
Johnson Computers repairs computers, along with selling and installing software on computers. Brian handles the repairs for the computers and is constantly asked by family and friends for assistance when they experience computer issues. In an effort to provide more personal income, Brian started doing repairs from his home on weekends and evenings, as a part-time venture. As most of the business is for family and friends, he does not want to charge as much as Johnson Computers does. During the budget process, Brian increased the budget for computer parts, and once approved, started to buy as many as the budget would allow. For the additional parts not needed by Johnson Computers, Brian took the parts home to use in his business. Brian makes sure the amount spent never exceeds the budgeted amount.
Explain how Brian’s use of the budget is considered fraudulent, and how the budget process should have found this issue.
What policies and procedures should Johnson Computers have in place to protect the business assets and prevent the business risk?
In: Accounting
Exercise 21A-5 a-c
Sage Hill Leasing Company signs an agreement on January 1, 2017,
to lease equipment to Cole Company. The following information
relates to this agreement.
1. | The term of the non-cancelable lease is 6 years with no renewal option. The equipment has an estimated economic life of 6 years. | |
2. | The cost of the asset to the lessor is $401,000. The fair value of the asset at January 1, 2017, is $401,000. | |
3. | The asset will revert to the lessor at the end of the lease term, at which time the asset is expected to have a residual value of $22,050, none of which is guaranteed. | |
4. | The agreement requires equal annual rental payments, beginning on January 1, 2017. | |
5. | Collectibility of the lease payments by Sage Hill is probable. |
a. Assuming the lessor desires a 8% rate of return on its investment, calculate the amount of the annual rental payment required.
b. Prepare an amortization schedule that is suitable for the lessor for the lease term.
c. Prepare all of the journal entries for the lessor for 2017 and 2018 to record the lease agreement, the receipt of lease payments, and the recognition of revenue. Assume the lessor’s annual accounting period ends on December 31, and it does not use reversing entries.
In: Accounting
Fey Company’s organization chart includes the president; the vice president of production; three assembly plants—Dallas, Atlanta, and Tucson; and two departments within each plant—Machining and Finishing. Budget and actual manufacturing cost data for July 2017 are as follows.
Finishing Department—Dallas: direct materials $42,500 actual, $44,000 budget; direct labor $83,400 actual, $82,000 budget; manufacturing overhead $51,000 actual, $49,200 budget.
Machining Department—Dallas: total manufacturing costs $220,000 actual, $219,000 budget.
Atlanta Plant: total manufacturing costs $424,000 actual, $420,000 budget.
Tucson Plant: total manufacturing costs $494,200 actual, $496,500 budget.
The Dallas plant manager’s office costs were $95,000 actual and $92,000 budget. The vice president of production’s office costs were $132,000 actual and $130,000 budget. Office costs are not allocated to departments and plants. Instructions Using the format shown in Illustration 10-19 (page 427), prepare the reports in a responsibility system for:
(a) The Finishing Department—Dallas.
(b) The plant manager—Dallas.
(c) The vice president of production.
In: Accounting
how does Apple INC. use Activity Based costing? 1. Describe the company and its business. 2. What was the scope of the ABC project? 3. What were the goals for the ABC project? 4. Summarize the results of the project.
In: Accounting
In: Accounting
a) How do standard costs are developed.
b) How do we calculate and interpret variances for direct materials.
c) What are the advantages and disadvantages of decentralization.
In: Accounting