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...
-
Preparing a budget is a waste of time. The strategic plan is what we work to accomplish. How would you respond to this comment?
-
Jill and George are married and file a joint return. They expect to have $425,000 of taxable income in the next year and are considering whether to purchase a personal residence that would provide...
-
Find the eigenvalues and eigenfunctions of the given Sturm-Liouville problems: a. \(y^{\prime \prime}+\lambda y=0, y^{\prime}(0)=0=y^{\prime}(\pi)\). b. \(\left(x y^{\prime}...
-
Wadkins Company, a machinery dealer, leased a machine to Romero Corporation on January 1, 2012. The lease is for an 8-year period and requires equal annual payments of $38,514 at the beginning of...
-
1.) Hawkins, LLC sold an office building that it used in its business for $600,000 cash plus the buyer is assuming a $40,000 loan on the building. Hawkins bought the building ten years ago for...
-
1. Which process should VBB choose to produce?? 2. How much would VBP be willing to pay for the testing that is currently offered, for each batch?? 3. Would we be considered a perfect test, at twice...
-
Identify some of the recommended actions that leaders can take to create conditions conducive to learning in an organization.
-
How do the principles of deontological ethics and consequentialist ethics differ in guiding moral actions, and what are the implications of each framework in resolving complex moral dilemmas ?
-
Constance Backhouse's work sheds light on the historical barriers faced by marginalized groups in accessing the legal profession and challenges systemic biases within the judiciary (2021, p. 17). A...
-
What are the potential ethical and societal consequences of embracing ethical egoism as a guiding moral philosophy, and how does it compare to altruistic approaches ?
-
Create a graphic that clearly shows the differences in statistics of families on WIC, TANF, and Food assistance, children in head start, poor children, eighth-grade dropouts, and school funding...
-
what ways does normative ethical theory provide a framework for evaluating moral decisions, and how does it interact with applied ethics in real-world contexts ?
-
Suppose that you have the following two loans with monthly payments and no origination costs: Loan amount Term (years) Interest rate $90,000 15 7% $80,000 20 6% If you will prepay in 18 years (216...
-
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...
-
Cost centers are often evaluated using: a. Variance analysis. b. Operating margin. c. Return on investment. d. Residual income.
-
Investment centers are often evaluated using: a. Standard cost variances. b. Return on investment. c. Residual income/EVA. d. Both b and c.
-
Profit centers are often evaluated using: a. Investment turnover. b. Income targets or profit budgets. c. Return on investment. d. Residual income.
Study smarter with the SolutionInn App