A B C D E F G 1 Chapter 8: Applying Excel 2 3 Data 4 Year 3 Quarter 1 2 3 4 1 2 45,000 65,000 105,000 60,000 90,000 100,000 5 Budgeted unit sales 6 7 • Selling price per unit •Raw materials required to produce one unit 7 per unit $ 65,000 75% 00 8 • 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 14 15 16 • Raw material costs 17 • Raw materials purchases are paid 18 and 19 • Accounts payable for raw materials, beginning balance $ Desired ending inventory of raw materials is • Raw materials inventory, beginning 25% 30% of the budgeted unit sales of the next quarter 12,000 units 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

A B C D E F G 1 Chapter 8: Applying Excel 2 3 Data 4 Year 3 Quarter 1 2 3 4 1 2 45,000 65,000 105,000 60,000 90,000 100,000 5 Budgeted unit sales 6 7 • Selling price per unit •Raw materials required to produce one unit 7 per unit $ 65,000 75% 00 8 • 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 14 15 16 • Raw material costs 17 • Raw materials purchases are paid 18 and 19 • Accounts payable for raw materials, beginning balance $ Desired ending inventory of raw materials is • Raw materials inventory, beginning 25% 30% of the budgeted unit sales of the next quarter 12,000 units 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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
The company just hired a new marketing manager who insists 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: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 45,000 65,000 105,000 60,000 90,000 100,000 Selling price per unit $7 What are the total expected cash disbursements for raw materials for the year under this revised budget?
Please help me with b, c, and d. Thanks!
The company just hired a new marketing manager who insists 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: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2Budgeted unit sales 45,000 65,000 120,000 65,000 80,000 90,000Selling price per unit $7 What are the total expected cash collections for the year under this revised budget?What is the total required production for the year under this revised budget? What is the total cost of raw materials to be purchased for the year under this revised budget? What are the total expected cash disbursements for raw…
Current Attempt in Progress The production manager at ABC Inc. is responsible for formulating the budget for his department. He will be evaluated on his ability to control costs. After considerable thought, he arrives at his best estimate of costs, and then adds a further 10% to the projections. Chances are he has Inflated the cost projections because that is the way it has always been done. O conservative accounting practise requires that he not under report expenses. O by overestimating expenses, it will make it easier for him to come in under budget and receive a favourable evaluation. Onone of the above.
Carson CPAS specializes in preparing 1040EZ returns for low-income clients. The firm charged $100 per return this year and budgeted $100 per return. Additional information for the firm includes: Actual Budgeted 800 750 $37,500 12,000 Returns processed Variable costs Fixed costs Prepare Carson's static budget and the static budget performance report. Note: Do not use negative signs with any of your answers. Note: Indicate whether the variance is favorable (F) or unfavorable (U) using the drop-down menu in the last column next to the variable amount. Budgeted returns Actual returns Returns processed variance Revenue Variable costs Fixed costs Net income $36,000 12,500 $ $ Actual Results 0 For U $ 0$ Budget Results $ 0$ Variances 0 0 0 0 For U ♦ + >
Please help me. Thankyou.
According to its original plan, Munoz Consulting Services Company plans to charge its customers for service at $125 per hour. The company president expects consulting services provided to customers to reach 55,000 hours at that rate. The marketing manager, however, argues that actual results may range from 49,000 hours to 61,000 hours because of market uncertainty. Munoz's standard variable cost is $46 per hour, and its standard fixed cost is $1,410,000. Required Develop flexible budgets based on the assumptions of service levels at 49,000 hours, 55,000 hours, and 61,000 hours.
The consulting company Clark Robinson and Morton CRM is in that never ending budgeting phase of the year. Realizing that they couldn't defer a technology update any longer the managers planned to replace all of the computers in the office. The old computers will be sold for market value. When the new computer has reached the end of their useful lives there will be sold as well. The cost of the combined new computers and annual software update should be more efficiency gains and increased volumes of sales at least that's what the managers are expecting. Information related to this investment is as follows. Cost of no computers $25,400. Salvage value of no computers at end of useful life 2400 dollars. Life of no computers in years five. Market value of all computers today equal to book value 1900 dollars. Annual software update costs necessary for all computers old or $3200. Annual operating cash inflows from efficiency gains and increased sales due to no computers $9600. Minimum…
The company just hired a new marketing manager who insists 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: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 45,000 65,000 105,000 60,000 90,000 100,000 Selling price per unit $7 What is the total cost of raw materials to be purchased for the year under this revised budget?