D Required Information The Chapter 8 Form worksheet is to be used to create your own...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
D Required Information The Chapter 8 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Data Budgeted unit sales Selling price per unit 1 Chapter 8: Applying Excel 2 3 4 5 6 7 B 9 Data Budgeted unit sales A 45,000 67. Selling price per unit Accounts receivable, beginning balance Sales collected in the quarter sales are made Year 2 Quarter 2 70,000 120,000 $ $ B 1 60,000 45,000 с 65,000 75% 2 7 per unit Year 3 Quarter 1 2 85,000 100,000 70,000 D 3 120.000 E 4 60,000 F Year 3 Quart 1 85,000 G 2 100,000 1 Chapter 8: Applying Excel 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Data Budgeted unit sales A 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 19 Accounts payable for raw materials, beginning balance $ $ $ $ B 1 45,000 7 per unit 65,000 75% 2 с 70,000 23,000 pounds D 3 120,000 5 pounds of the next quarter's production needs 25% 30% of the budgeted unit sales of the next quarter 12,000 units 4 0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase 81,500 60,000 Year 3 Quarter 1 85,000 G 2 100,000 a. What are the total expected cash collections for the year under this revised budget? Expected cash collections for the year b. What is the total required production for the year under this revised budget? Total required production for the year. c. What is the total cost of raw materials to be purchased for the year under this revised budget? Total cost of raw materials to be purchased for the year d. What are the total expected cash disbursements for raw materials for the year under this revised budget? Total expected cash disbursements for raw materials for the year D Required Information The Chapter 8 Form worksheet is to be used to create your own worksheet version of the Review Problem in the text. Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Data Budgeted unit sales Selling price per unit 1 Chapter 8: Applying Excel 2 3 4 5 6 7 B 9 Data Budgeted unit sales A 45,000 67. Selling price per unit Accounts receivable, beginning balance Sales collected in the quarter sales are made Year 2 Quarter 2 70,000 120,000 $ $ B 1 60,000 45,000 с 65,000 75% 2 7 per unit Year 3 Quarter 1 2 85,000 100,000 70,000 D 3 120.000 E 4 60,000 F Year 3 Quart 1 85,000 G 2 100,000 1 Chapter 8: Applying Excel 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Data Budgeted unit sales A 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 19 Accounts payable for raw materials, beginning balance $ $ $ $ B 1 45,000 7 per unit 65,000 75% 2 с 70,000 23,000 pounds D 3 120,000 5 pounds of the next quarter's production needs 25% 30% of the budgeted unit sales of the next quarter 12,000 units 4 0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase 81,500 60,000 Year 3 Quarter 1 85,000 G 2 100,000 a. What are the total expected cash collections for the year under this revised budget? Expected cash collections for the year b. What is the total required production for the year under this revised budget? Total required production for the year. c. What is the total cost of raw materials to be purchased for the year under this revised budget? Total cost of raw materials to be purchased for the year d. What are the total expected cash disbursements for raw materials for the year under this revised budget? Total expected cash disbursements for raw materials for the year
Expert Answer:
Answer rating: 100% (QA)
Step 1 Solution a Schedule of expected cash collection Particulars Quarter1 Quarter2 Quarter3 Quarte... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-1259307416
16th edition
Authors: Ray Garrison, Eric Noreen, Peter Brewer
Posted Date:
Students also viewed these accounting questions
-
The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the...
-
The College Bookstore has just hired a new manager, one with a business background. Claudia Markman has been charged with increasing the profitability of the bookstore, with the profits going to the...
-
The Chapter 8 Form worksheet is to be used to create your own worksheet VersioH lequirement 2: he company has just hired a new marketing manager who insists that unit sales can be dramatically...
-
Ask survey subjects to estimate the length of 1 minute without looking at a watch or clock. Each subject should say go at the beginning of the minute and then stop when he or she thinks that 1 minute...
-
Which would be most affected in the event of an interest rate increase the price of a five-year coupon bond that paid coupons only in years 3, 4, and 5 or the price of a five-year coupon bond that...
-
REH Corporations most recent dividend was $3 per share, its expected annual rate of dividend growth is 5%, and the required return is now 15%. A variety of proposals are being considered by...
-
Zappos.com is a popular website known mainly for its discounted shoe sales. In 2012, a hacker hacked into the Zappos website in an effort to obtain the personal account information of Zappos...
-
The Ingalls Corporation is in the process of negotiating a loan for expansion purposes. The books and records have never been audited, and the bank has requested that an audit be performed. Ingalls...
-
Assume a simultaneous open market purchase of 100 million from the Bank of England and a repayment of a discount loan of 5 million from Bank A to the Bank of England. Show the overall change in their...
-
Forecasted financial statements are given Sales (all on credit) Cost of Goods Sold Gross Profit Selling and Administrative Expense Rent Expense Depreciation Expense Operating profit (EBIT) Interest...
-
R-134a is contained in a piston-cylinder device at T1= -12 C and P1= 0.4 MPa. The fluid is heated isobarically such that V-20V. Heat then added at constant volume until we get T3-52 C. Calculate h,...
-
The communication method that is used for large audiences or large volumes of information and requires recipients to access the content at their own discretion, is called communication. a. push b....
-
Why is an Agile project planned in detail just one iteration at a time? Give an example of a project that would work well using Agile scheduling and another example of a project for which traditional...
-
Give an example of what is given up in a project when it is crashed and when it is fast-tracked and an appropriate time to use each.
-
What is the purpose of an order of magnitude cost estimate?
-
What are the two techniques used to compress a project schedule?
-
Francis is interested in becoming a shareholder of Suncor Inc. but believes that Suncor Inc. shares are undervalued in relation to the financial performance and development prospects of the global...
-
Compare and contrast licensing and subcontracting.
-
Apex Company prepared the statement of cash flows for the current year that is shown below: Required: Compute Apex Companys free cash flow for the current year. ompany Statement of Cash...
-
What is the major criticism of the payback and simple rate of return methods of making capital budgeting decisions?
-
Bill has just returned from a duck hunting trip. He has brought home eight ducks. Bills friend, John, disapproves of duck hunting, and to discourage Bill from further hunting, John has presented him...
-
Try drawing up a statement of financial position for Jerry and Company as at 4 March.
-
Assume a business owns a 50 percent stake in a gold mine. As this ownership stake will not give control over the whole of the gold mine, can this resource be regarded as an asset of the business?
-
Does the fact that the level of inventories (and, perhaps, of other factors) may not be typical of their levels at other times in the reporting period pose a problem for external users seeking to...
Study smarter with the SolutionInn App