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...
-
Describe regression variation in terms of variation in Y.
-
Data related to the acquisition of timber rights and intangible assets during the current year ended December 31 are as follows: a. On December 31, the company determined that $3,400,000 of goodwill...
-
Compute payback periodequal cash inflows (Learning Objective 2) Refer to the Allegra Data Set. Calculate the CD-player projects payback period. If the CD project had a residual value of $100,000,...
-
1. If a sample of 50 prospective customers is selected and no free premium channels are included in the 3- For- All service offer, given past results, what is the probability that a. fewer than 3...
-
Suppose the n-th partial sum of the series S = _ =] ak is n 2n - 10 Sn = > ak = 7n + 8 k=1 Then, the following hold (with n 2 2): a 1 = an =
-
Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSRs products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per...
-
Ahmad Blackburn has just started work in the manufacturing facility of Spring Fork Company. This is Ahmad s first job for a manufacturing company; previously he has only worked for retail companies....
-
Bramble Advertising Company's trial balance at December 31 shows Supplies $8,780 and Supplies Expense $0. On December 31, there are $2,120 of supplies on hand. (a1) Your answer is partially correct....
-
A cable is attached between B and C. The cable is attached in such a way that it has a tension of TBC along its length. The tensile force will Ittempt to pull B toward C. The force exerted on B has a...
-
Kang Corporation is considering purchasing a new delivery truck. The truck has many advantages over the company's current truck. The new truck would cost $147,800. Because of the reduced maintenance...
-
For each, state whether common shares, retained earnings, and cash flow will increase, decrease, or remain unchanged. Quantify the amount of any increases or decreases. Retained Earnings No....
-
You are evaluating two different silicon wafer milling machines. The Techron I costs $270,000, has a three-year life, and has pretax operating costs of $73,000 per year. The Techron II costs...
-
38. A bond issue with a maturity value of $100,000 and a discount of $4,200 is retired at 102. What is the gain or loss on this transaction? A. $6,200 gain B. $4,200 gain C. $2,000 gain D. $4,200...
-
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.
-
Use Fleury's algorithm to construct an Euler trail for the given graph beginning at vertex \(f\) of your choice. a d a 6 b
-
Use the graphs shown to determine whether the sequence of vertices \(d ightarrow b ightarrow c ightarrow f ightarrow e ightarrow d\) is a Hamilton cycle, an Euler circuit, both, or neither. C m n d e...
-
Use the figure shown to find the weight of the given Hamilton cycle: twxuy vs rqt 13 3 q r S 1 7 2 6 t u 14 15 12 11 8 5 W X 9 10
Study smarter with the SolutionInn App