Chapter 8 Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted Unit Sales 40,000 60,000 100,000 50,000 70,000 80,000 Selling price per unit $8 Accounts receivable, beginning balance $65,000 Sales collected in the quarter sales are made 75% Sales collected in the quarter after sales are made 25% Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter Finished goods inventory, beginning 12,000 units Raw materials required to produce one unit 5 pounds Desired ending inventory of raw materials is 10% of the next quarter's production needs Raw materials inventory, beginning 23,000 pounds Raw materials cost $0.80 per pound Raw materials purchases are paid 60% in the quarter the purchases are made and 40% in the quarter following purchase Accounts payable for raw materials, beginning balance $81,500

Chapter 8 Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted Unit Sales 40,000 60,000 100,000 50,000 70,000 80,000 Selling price per unit $8 Accounts receivable, beginning balance $65,000 Sales collected in the quarter sales are made 75% Sales collected in the quarter after sales are made 25% Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter Finished goods inventory, beginning 12,000 units Raw materials required to produce one unit 5 pounds Desired ending inventory of raw materials is 10% of the next quarter's production needs Raw materials inventory, beginning 23,000 pounds Raw materials cost $0.80 per pound Raw materials purchases are paid 60% in the quarter the purchases are made and 40% in the quarter following purchase Accounts payable for raw materials, beginning balance $81,500

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 2CE: Refer to Cornerstone Exercise 8.1, through Requirement 1. FlashKick requires ending inventory of...

See similar textbooks

Similar questions

Chapter 8 Applying Excel Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted Unit Sales 40,000 60,000 100,000 50,000 70,000 80,000 Selling price per unit $8 Accounts receivable, beginning balance $65,000 Sales collected in the quarter sales are made 75% Sales collected in the quarter after sales are made 25% Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter Finished goods inventory, beginning 12,000 units Raw materials required to produce one unit 5 pounds Desired ending inventory of raw materials is 10% of the next quarter's production needs Raw materials inventory, beginning 23,000 pounds Raw materials cost $0.80 per pound Raw materials purchases are paid 60% in the quarter the purchases…
Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit • Accounts receivable, beginning balance • Sales collected in the quarter sales are made • Sales collected in the quarter after sales are made • Desired ending finished goods inventory is • Finished goods inventory, beginning • Raw materials required to produce one unit • Desired ending inventory of raw materials is • Raw materials inventory, beginning • Raw material costs • Raw materials purchases are paid and • Accounts payable for raw materials, beginning balance $12 per unit $65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units 5 pounds 10% of the next quarter's production needs 23,000 pounds $0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase $81,500 •Direct labor cost per hour •Direct labor hour per unit $15 per hour 0.2 hour per unit $2 per hour $60,000 •Variable MOH rate…
Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2 Budgeted unit sales 40,000 60,000 100,000 50,000 70,000 80,000 • Selling price per unit $8 per unit • Accounts receivable, beginning balance $65,000 • Sales collected in the quarter sales are made 75% • Sales collected in the quarter after sales are made 25% • Desired ending finished goods inventory is 30% of the budgeted unit sales of the next quarter • Finished goods inventory, beginning 12,000 units • Raw materials required to produce one unit 5 pounds • Desired ending inventory of raw materials is 10% of the next quarter's production needs • Raw materials inventory, beginning 23,000 pounds • Raw material costs $0.80 per pound • Raw materials purchases are paid 60% in the quarter the purchases are made and 40% in the…
A company expects the following sales for the coming year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units 50,000 40,000 70,000 90,000 Average selling price $6 $6 $6 $8 Budgeted sales revenue for the year is: a. $1,050,000. b. $1,260,000. c. $1,155,000. d. $1,680,000. e. It is impossible to tell from this information.
Download the Applying Excel form and enter formulas in all cells that contain question marks. For example, in cell B26 enter the formula "= B5". Required: 1. Check your worksheet by changing the budgeted unit sales in Quarter 2 of Year 2 in cell C5 to 75,000 units. The total expected cash collections for the year should now be $2,085,000. The required production for the year should be 274,000 units. The cost of raw materials to be purchased for the year should be $1,106,800, whereas the total cash disbursements for the year should be $1,095,980. If you do not get this answer, find the errors in your worksheet and correct them.
Question 32 The following information is taken from the production budget for the first quarter: Sales budgeted for the quarter 684,000 units Desired ending finished goods Beginning inventory in units 4,800 units 1,800 units How many units should the company produce during the quarter? 681,000 a. Ob. 688,800 Oc. 687,000 711,000
Question 1 The marketing department of HASF Corporations has submitted the following sales forecast for the upcoming fiscal year (all sales are on account) Q1 Q2 Q3 Q4 total Budgeted units sales ? 10% increase 10 % decrease 16,335 62,685 Budget selling price per unit 18 18 18 ? 18 budgeted sales revenue ? 297,000 ? 294,030 ? Other information Each quarter ending finished goods inventory is 20% of next month units sold. Next year first quarter beginning inventory is 3,000. Each finished units require 3 grams of raw material that cost Rs 3 per unit. Management desired to end each quarter with an inventory of raw material equal to 15% of the current quarter production needs Beginning inventory of raw material in first quarter 3,000 grams FIND UNIT SALES of Q1 Answer format should be like : 10000 donot USE COMMA's or Currency or UNITs. Answer should be plain…
Function: SUM; Formula: Subtract, Multiply; Cell Referencing Using Excel to Prepare a Production Budget PROBLEM Paige Company estimates that following unit sales and desired inventory level for the four quarters of the year ending December 31, 2022. Quarter 1 sales Quarter 2 sales Quarter 3 sales Quarter 4 sales Desired ending finished goods inventory based on next quarter's expected unit sales Unit selling price 10,000 14,000 15,000 18,000 25% $ 70.00 Prepare a production budget by quarters for the first 6 months of 2022. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or this work area as indicated. Use the SUM function with cell referencing for totals. Paige Company Production Budget For the Six Months Ending June 30, 2022 Quarter 1 10,000 Expected unit sales Add: Desired ending finished goods units Total required units Less: Beginning finished goods units Required production…
Question 1 Plagued Engineering Limited produces two products, Niks and Args. The budget for the forthcoming year to 31 March 19X8 is to be prepared. Expectations for the forthcoming year include the following. Finished products Niks Args The sales director has estimated the following: demand for the company’s products will be 4,500 units 4,000 units they will market at a selling price per unit of $32 $44 the closing stock of finished products at 31 March 19X8 is required to be 400 units 1,200 units the opening stock of finished products at 1 April 19X7 is 900 units 200 units the unit cost of this opening stock will be $20 $28 the amount of plant capacity required for each unit of product is: machining…
D Question 5 Witherspoon Inc. has compiled the following data in order to put together their first quarter operating budget for 20XX Sales (units) January 55,200 February 48,000 March 41,000 Apri 37,000 Additional information: Witherspoon sells each unit for $95. Company policy is to have 30% of next month's sales (in units) in ending finished goods inventory. This policy was met in December. Required: 1. What are the total dollar sales for the quarter? Hint: writo out I sales budget but you do not need to show in your answer. 2. (a) What is the desired ending Inventory for February? (b) What are the Total Units to be Produced for the Quarter? Hint: write out a production budget but you do not need to show in your answer.
16.66points eBook Item 1 Electro Company manufactures transmissions for electric cars. Management reports ending finished goods inventory for the first quarter at 139,200 units. The following unit sales are budgeted during the rest of the year: second quarter, 232,000 units; third quarter, 391,000 units; and fourth quarter, 376,500 units. Company policy calls for the ending finished goods inventory of a quarter to equal 60% of the next quarter's budgeted unit sales. Prepare a production budget for both the second and third quarters that shows the number of transmissions to manufacture.
Question 6 View Policies Current Attempt in Progress Crane Company determines that 59000 pounds of direct materials are needed for production in July. There are 3700 pounds of direct materials on hand at July 1 and the desired ending inventory is 3300 pounds. If the cost per unit of direct materials is $3, what is the budgeted total cost of direct materials purchases? ort $175800 O $180600. O $178200. O $173400. ea Chp ins prt sc fho 12 home delete % 5 & 7 backspace lock T P hom G H K enter B pause t shift ctri NM N

SEE MORE QUESTIONS

Recommended textbooks for you

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

GET THE APP

About FAQ Academic Integrity Sitemap Document Sitemap

Contact Bartleby Contact Research (Essays)High School Textbooks Literature Guides Concept Explainers by Subject Essay Help Mobile App

GET THE APP

Privacy

Your CA Privacy Rights

Your NV Privacy Rights

About Ads

Manage My Data

bartleby, a Learneo, Inc. business

Chapter 8 Applying Excel

Data	Year 2 Quarter	Year 3 Quarter
	1	2	3	4	1	2
Budgeted Unit Sales	40,000	60,000	100,000	50,000	70,000	80,000

Selling price per unit	$8
Accounts receivable, beginning balance	$65,000
Sales collected in the quarter sales are made	75%
Sales collected in the quarter after sales are made	25%
Desired ending finished goods inventory is	30%	of the budgeted unit sales of the next quarter
Finished goods inventory, beginning	12,000	units
Raw materials required to produce one unit	5	pounds
Desired ending inventory of raw materials is	10%	of the next quarter's production needs
Raw materials inventory, beginning	23,000	pounds
Raw materials cost	$0.80	per pound
Raw materials purchases are paid	60%	in the quarter the purchases are made
and	40%	in the quarter following purchase
Accounts payable for raw materials, beginning balance	$81,500