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

Please help me with b, c, and d. Thanks!

Before the year began, the following static budget was developed for the estimated sales of 100,000. Sales are sluggish and management needs to revise its budget. Use this information to prepare a flexible budget for 80,000 and 90,000 units of sales.       Flexible Budget   100,000 80,000 90,000 Sales $3,580,000 $fill in the blank 1 $fill in the blank 2 Cost of Goods Sold       Direct Material $900,000 $fill in the blank 3 $fill in the blank 4 Direct Labor 1,100,000 fill in the blank 5 fill in the blank 6 Variable Manufacturing Overhead 240,000 fill in the blank 7 fill in the blank 8 Fixed Manufacturing Overhead 70,000 fill in the blank 9 fill in the blank 10 Cost of Goods Sold $2,310,000 $fill in the blank 11 $fill in the blank 12 Gross Profit $1,270,000 $fill in the blank 13 $fill in the blank 14 Variable Sales and Administrative Expenses 100,000 fill in the blank 15 fill in the blank 16 Fixed Sales and Administrative Expenses 940,000 fill in the blank…

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 do not give solution in image format

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?