Chapter 8: (Algo) Applying Excel: Exercise (Part 2 of 2) Requirement 2: The company has just...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Chapter 8: (Algo) Applying Excel: Exercise (Part 2 of 2) 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 Data 4 5 6 7. Selling price per unit 8 Budgeted unit sales . . Accounts receivable, beginning balance 9 • Sales collected in the quarter sales are made 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 18 19 Accounts payable for raw materials, beginning balance . A . 1 50,000 $7 Raw materials purchases are paid and. Year 2 Quarter 2 3 70,000 110,000 $ $ $ $ B 1 4 70,000 50,000 C 2 7 per unit Year 3 Quarter 1 90,000 70.000 2 95,000 D 3 110,000 E 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 4 70,000 65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units F Year 3 Quarter 1 90,000 G 2 95,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 e. After seeing this revised budget, the production manager cautioned that due to the current production constraint, a complex milling machine, the plant can produce no more than 80,000 units in any one quarter. Is this a potential problem? No Yes Chapter 8: (Algo) Applying Excel: Exercise (Part 2 of 2) 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 Data 4 5 6 7. Selling price per unit 8 Budgeted unit sales . . Accounts receivable, beginning balance 9 • Sales collected in the quarter sales are made 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 18 19 Accounts payable for raw materials, beginning balance . A . 1 50,000 $7 Raw materials purchases are paid and. Year 2 Quarter 2 3 70,000 110,000 $ $ $ $ B 1 4 70,000 50,000 C 2 7 per unit Year 3 Quarter 1 90,000 70.000 2 95,000 D 3 110,000 E 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 4 70,000 65,000 75% 25% 30% of the budgeted unit sales of the next quarter 12,000 units F Year 3 Quarter 1 90,000 G 2 95,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 e. After seeing this revised budget, the production manager cautioned that due to the current production constraint, a complex milling machine, the plant can produce no more than 80,000 units in any one quarter. Is this a potential problem? No Yes
Expert Answer:
Answer rating: 100% (QA)
To answer the questions regarding the revised budget lets calculate the required values step by step a Total expected cash collections for the year under the revised budget To calculate the total expe... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Company Case Kraft Heinz: Once a Taste Maker Now Struggles as Consumer Tastes Change In the era of high-tech Silicon Valley startups, the Googles, Amazons, and Facebooks of the world seem to get all...
-
discuss case study a bout remote analysis during covid 1 9 - 1 9 virus
-
Carefully read the letters of John Locke to discuss what he is telling us about his times and what he envisions for an eventual approach to educating children in general, beyond just privileged...
-
Action Quest Games Inc. initially records all prepaid costs as assets and all revenue collected in advance as liabilities. The company adjusts its accounts annually. The following information is...
-
Microfinance has grown most quickly in low-income countries, but many poorer households in richer countries also lack access to highquality financial services at reasonable prices. Why would...
-
Absolute Leasing, Inc. agrees to lease equipment to Allen, Inc. on January 1, 2012. They agree on the following terms: 1) The normal selling price of the equipment is $350,000 and the cost of the...
-
A company forgot to record four adjustments during 2017. Which one of the following omissions of adjustments will overstate assets? a. Sales made during the last week of the period are not recorded....
-
Pool Corporation, Inc., sells swimming pool supplies and equipment. It is a publicly traded corporation that trades on the NASDAQ exchange. The majority of Pools customers are small, family-owned...
-
Your company has $100 million available for investment in the following potential investment opportunities: Project NPV Initial Investment $15 million $50 million $10 million $60 million $35 million...
-
What types of problems can be addressed by queuing theory?
-
Describe the general frequency response of a coupling capacitor, a bypass capacitor, and a load capacitor.
-
Why is the bandwidth of a cascode amplifier larger, in general, than that of a simple common-emitter amplifier?
-
How should segregation of duties be evaluated in an EDP setting?
-
What type of sampling procedure is likely to be used when the documents to be tested are not prenumbered? Why?
-
The IMA Statement of Ethical Professional Practice identifies four ethical standards, three of which are competence, confidentiality, and integrity (see "Ethics Center" on IMA website). Relying on...
-
Which one of the following anhydrous chloride is not obtained on direct heating of its hydrated chloride? (A) BaCl2 (B) CaClz (C) MgCl2 (D) SrCl2
-
Jenny earns $34,500 in 2012. Calculate the FICA tax that must be paid by: Jenny: ..............................Soc,Sec. ..................$______________...
-
Sherry rents her vacation home for 6 months and lives in it for 6 months during the year. Her gross rental income during the year is $4,000. Total real estate taxes for the home are $950, and...
-
Mallory Corporation has a calendar year-end. The corporation has paid estimated payments of $10,000 during 2012 but still owes an additional $5,000 for its 2012 tax year. a. When is the 2012 tax...
-
Ibis Company enters into a concession agreement with the British government. Ibis pays the government a \($10,000,000\) (U.S.) signing bonus and agrees to pay the government royalties of 8% of gross...
-
What does a high net wells to gross wells ratio indicate?
-
What is the value added ratio? What does a high (low) value added ratio indicate?
Study smarter with the SolutionInn App