The company has just hired a new marketing manager who insists that unit sales can be...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 8 Data Budgeted unit sales A 1 50,000 $7 Selling price per unit Accounts receivable, beginning balance 9. Sales collected in the quarter sales are made Year 2 Quarter 2 70,000 10 Sales collected in the quarter after sales are made 11. Desired ending finished goods inventory is 12 Finished goods inventory, beginning 13. Raw materials required to produce one unit 14-Desired ending inventory of raw materials is 15 Raw materials inventory, beginning 16 Raw material costs 17 Raw materials purchases are paid 18 and 19 Accounts payable for raw materials, beginning balance 110,000 SS $ $ B 1 70,000 50,000 C 65,000 75% 2 7 per unit Year 3 Quarter 1 2 90,000 95,000 70,000 D 3 110,000 5 pounds 10% of the next quarter's production needs 23,000 pounds E 0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase 81,500 4 25% 30% of the budgeted unit sales of the next quarter 12,000 units 70,000 F Year 3 Quarter 1 90,000 19 G 2 95,000 a. What are the total expected cash collections for the year under this revised budget? 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 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 8 Data Budgeted unit sales A 1 50,000 $7 Selling price per unit Accounts receivable, beginning balance 9. Sales collected in the quarter sales are made Year 2 Quarter 2 70,000 10 Sales collected in the quarter after sales are made 11. Desired ending finished goods inventory is 12 Finished goods inventory, beginning 13. Raw materials required to produce one unit 14-Desired ending inventory of raw materials is 15 Raw materials inventory, beginning 16 Raw material costs 17 Raw materials purchases are paid 18 and 19 Accounts payable for raw materials, beginning balance 110,000 SS $ $ B 1 70,000 50,000 C 65,000 75% 2 7 per unit Year 3 Quarter 1 2 90,000 95,000 70,000 D 3 110,000 5 pounds 10% of the next quarter's production needs 23,000 pounds E 0.80 per pound 60% in the quarter the purchases are made 40% in the quarter following purchase 81,500 4 25% 30% of the budgeted unit sales of the next quarter 12,000 units 70,000 F Year 3 Quarter 1 90,000 19 G 2 95,000 a. What are the total expected cash collections for the year under this revised budget? 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)
To calculate the total expected cash collections total required production total cost of raw materials to be purchased and total expected cash disburs... 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 Excel worksheet form that appears below is to be used to recreate the Review Problem related to Mynor Corporation. Download the workbook containing this form from Connect, where you will also...
-
List the last eleven-year net incomes of your company and the competitor. Calculate their means, annual growth rate, mean annual growth rates, and standard deviations (STD) in Excel. Copy the results...
-
The Excel worksheet form that follows is to be used to recreate the Review Problem related to Mynor Corporation. Download the workbook containing this form at from Connect. On the website you will...
-
Aquarius -EAST B Capricornus Horizon Sagittarius SOUTH SUN Scorpius Libra WEST- E Description: If you could see both the Sun and the other stars during the day, this is what the sky would look like...
-
In a recent 10-K report, United Parcel Service states it is the worlds largest package delivery company, a leader in the U.S. less-than-truckload industry, and a global leader in supply chain...
-
Write a program that transforms numbers 1, 2, 3, , 12 into the corresponding month names January, February, March, , December. Make a very long string "January February March ...", in which you add...
-
Use the financial data for Randa Merchandising, Inc., in Exercise 13-13 to prepare its income statement for calendar-year 2017. (Ignore the earnings per share section.) Data From Exercise 13.13 In...
-
Transactions for Mehta Company for the month of May are presented below. Prepare journal entries for each of these transactions. (You may omit explanations.) May 1 B.D. Mehta invests $4,000 cash in...
-
- Consider an asymmetric Cournot duopoly game, where the two firms have different costs of production. Firm 1 selects quantity 91 at a pro- duction cost of 2q. Firm 2 selects quantity 92 and pays the...
-
The Golden Oranges Nursery, which provides facilities for pre-school children on a commercial basis, is preparing its cash budget for next year. A profile of the estimated revenues and expenses for...
-
Governor Asa Hutchinson announced that nurses in Arkansas would receive a $1,000 monthly bonus payment during the pandemic, and that number would double to $2,000 if they worked in a facility with a...
-
A person's metabolic rate tends to go up after eating a meal and then, after some time has passed, it returns to a resting metabolic rate. This phenomenon is known as the thermic effect of food, and...
-
What transaction-related objective is described by ensuring that recorded purchase transactions represent inventories acquired during the period?
-
In operations management, what is the primary purpose of a Gantt chart? Explain
-
What is the difference between a bank and a central bank digital currency (CBDC)? What is the difference between Central Bank Digital Currency (CBDC) and Cryptocurrency (CC)? Which one is more likely...
-
You have replaced the former audit partner Brett of the auditing firm Moira & Stella (M&S). You find the following independent engagement is potentially in breach of the independence requirements of...
-
Your company has been using traditional costing and is considering moving to Activity Based Costings for a number of product lines. Explain what is meant by Activity Based Costings, how it differs...
-
Does log 81 (2401) = log 3 (7)? Verify the claim algebraically.
-
MediSecure, Inc., produces clear plastic containers for pharmacies in a process that starts in the Molding Department. Data concerning that department's operations in the most recent period appear...
-
Lucido Products markets two computer games: Claimjumper and Makeover. A contribution format income statement for a recent month for the two games appears on the following page: Required: 1. Compute...
-
Explain how fixed manufacturing overhead Costs are shifted from one period to another under absorption costing.
-
The liquidity premium hypothesis also holds that issuers of bonds prefer to issue long-term bonds to lock in borrowing costs. How would this preference contribute to a positive liquidity premium?
-
Go to stockcharts.com/freecharts/yieldcurve.php where you will find a dynamic or living yield curve, a moving picture of the yield curve over time. Hit the Animate button to start the demonstration....
-
Suppose that the price of 3-year zero-coupon bonds is $816.30. What is the forward rate for the third year? How would you construct a synthetic 1-year forward loan that commences at t = 2 and matures...
Study smarter with the SolutionInn App