![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
thumb_up100%
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
Unit Sales Unit Selling
Product and Area
Total Sales
Volume
Price
Backyard Chef:
Maine
Vermont
New Hampshire
Total
Master Chef:
$
Maine
Vermont
New Hampshire
Total
Total revenue from sales](https://content.bartleby.com/qna-images/question/b51f18cc-dc60-43bb-adcc-2b0ba447702d/55ffd95f-f0e5-4e8c-9f89-1ac2bf2baf7d/isz1eei_thumbnail.png)
Transcribed Image Text:Required:
1. Prepare a sales budget for July.
Gourmet Grill Company
Sales Budget
For the Month Ending July 31
Unit Sales Unit Selling
Product and Area
Total Sales
Volume
Price
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
Master
Chef
Chef](https://content.bartleby.com/qna-images/question/b51f18cc-dc60-43bb-adcc-2b0ba447702d/55ffd95f-f0e5-4e8c-9f89-1ac2bf2baf7d/uyaajp_thumbnail.png)
Transcribed Image Text: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
Master
Chef
Chef
Expert Solution
![Check Mark](/static/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 2 images
![Blurred answer](/static/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Vaibhav Subject - Accountingarrow_forwardVikrambahiarrow_forwardVinall Corporation makes one product and has provided the following information to help prepare the master budget for the next four months of operations: Budgeted selling price per unit $ 86 Budgeted unit sales (all on credit): July 9, 550 August 11, 800 September 10, 450 October 11,400 Raw materials requirement per unit of output 2.1 pounds Raw materials cost $ 2.1 per pound Direct labor requirement per unit of output 2.3 direct labor-hours Direct labor wage rate $ 25.5 per direct labor-hour Credit sales are collected: 30% in the month of the sale 70% in the following month Raw materials purchases are paid: 20% in the month of purchase 80% in the following month The ending finished goods inventory should equal 20% of the following month's sales. The ending raw materials inventory should equal 20% of the following month's raw materials production needs. PLEASE SHOW ALL EQUATIONS IN EXCEL FORMAT! Required: What are the budgeted sales for August? What are the expected cash collections…arrow_forward
- Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor $16.40q Indirect labor $4,000 + $1.40q Utilities $5,300 + $0.30q Supplies $1,600 + $0.10q Equipment depreciation $18,500 + $3.00q Factory rent $8,200 Property taxes $2,500 Factory administration $13,600 + $0.60q The Production Department planned to work 4,400 labor-hours in March; however, it actually worked 4,200 labor-hours during the month. Its actual costs incurred in March are listed below: Actual Cost Incurred in March Direct labor $ 70,480 Indirect labor $ 9,340 Utilities $ 7,010 Supplies $ 2,250 Equipment depreciation $ 31,100 Factory rent $ 8,600 Property taxes $ 2,500 Factory…arrow_forwardPackaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Cost Formulas $16.30q $4,300 +$1.50g $5,300 +$0.40g $1.400+ $0.30q $18,200+ $2.70g $8,400 $13,800+ $0.60g $2,600 The Production Department planned to work 4,200 labor-hours in March; however, it actually worked 4,000 labor-hours during the month. Its actual costs incurred in March are listed below: Direct labor Actual Cost Incurred in March $ 66,780 Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Required: $ 9,780 $ 7,370 $ 2,870 $ 29,000 $ 8.800 $ 2,600 $ 15,550 1. Prepare the Production…arrow_forwardThe production supervisor of the Machining Department for Celtic Company agreed to the following monthly static budget for the upcoming year: Celtic Company Machining Department Monthly Production Budget Wages $290,000 Utilities 14,000 Depreciation 23,000 Total $327,000 The actual amount spent and the actual units produced in the first three months in the Machining Department were as follows: Amount Units Spent Produced January $308,000 70,000 February 290,000 63,000 March 277,000 57,000 The Machining Department supervisor has been very pleased with this performance because actual expenditures for January-March have been less than the monthly static budget of $327,000. However, the plant manager believes that the budget should not remain fixed for every month but should "flex" or adjust to the volume of work that is produced in the Machining Department. Additional budget information for the Machining Department is as follows: Wages per hour $19.00 Utility cost per direct labor hour…arrow_forward
- Echo Amplifiers prepared the following sales budget for the first quarter of 2018: Jan. Feb. Mar. Units 900 1,300 1,400 Sales price $100 $100 $100 Budgeted sales $90,000 $130,000 $140,000 It also has this additional information related to its expenses: Direct material per unit $1.50 Direct labor per unit 2 Variable manufacturing overhead per hour 0.40 Fixed manufacturing overhead per month 3,000 Sales commissions per unit 16 Sales salaries per month 5,100 Delivery expense per unit 0.50 Factory utilities per month 4,000 Administrative salaries per month 20,000 Marketing expenses per month 7,000 Insurance expense per month 12,000 Depreciation expense per month 10,000 Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018. Enter all amounts as positive numbers.arrow_forwardPlease help mearrow_forwardHarlow Parts produces a single product at its Superior Plant. The master budget for July follows: Harlow Parts Superior Plant Master Budget (For July) Quantity Revenue Variable manufacturing cost Variable Selling, General and Administrative cost Contribution margin Fixed manufacturing cost Fixed Selling, General and Administrative cost Operating profit The following operating income statement shows the actual results for July: Harlow Parts Superior Plant Operating Results (For July) Quantity (units) Revenue Variable manufacturing cost Variable Selling, General and Administrative cost Contribution margin 8,800 $ 1,560,000 721,600 97,600 $ 740,800 211, 200 334,000 $ 195,600 Fixed manufacturing cost Fixed Selling, General and Administrative cost Operating profit 10,200 $ 1,726,800 879,954 110,640 $ 736,206 220,320 344,000 $ 171,886 < Prev 10 of 10 ‒‒‒ Nextarrow_forward
- Consider Derk's budget information: materials to be used totals $62,100; direct labor totals $199,900; factory overhead totals $402,700; work in process inventory January 1, $188,800; and work in progress inventory on December 31, $194,100. What is the budgeted cost of goods manufactured for the year? a.$853,500 b.$664,700 c.$659,400 d.$194,100arrow_forwardes Required information [The following information applies to the questions displayed below.] Morganton Company makes one product and it provided the following information to help prepare the master budget: a. The budgeted selling price per unit is $65. Budgeted unit sales for June, July, August, and September are 9,000, 21,000, 23,000, and 24,000 units, respectively. All sales are on credit. b. Thirty percent of credit sales are collected in the month of the sale and 70% in the following month. c. The ending finished goods inventory equals 30% of the following month's unit sales. d. The ending raw materials inventory equals 20% of the following month's raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. The raw materials cost $2.70 per pound. e. Twenty percent of raw materials purchases are paid for in the month of purchase and 80% in the following month. f. The direct labor wage rate is $14 per hour. Each unit of finished goods requires two…arrow_forwardhelp plsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
![Text book image](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education