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

Please do not give solution in image format thanku
You are given the following information in respect of a company:Budgeted output 60 000 unitsSelling Price per unit OMR 120Variable Cost per unit OMR 100Total Fixed Costs OMR 200,000Draw a break-even chart showing the breakeven point. If the selling price is reduced to OMR 100 per unit, what will be the new break- even point?
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?
Blitzle Inc has prepared the following budget data: Sales Volume 15,000 Unit Selling Price ₱750 Unit Variable Expenses ₱550 Fixed Manufacturing Expenses ₱1,600,000 Fixed Selling & Administrative Expenses ₱1,400,000 An advertising agency claims that an aggressive advertising campaign would enable the company to increase its unit sales by 25%. The maximum amount that the company can pay for advertising and obtain a net operating income of ₱350,000 would be ₱___________.
Sales Revenue Approach, Variable Cost Ratio, Contribution MarginRatioArberg Company’s controller prepared the following budgeted income statement for thecoming year: Required:1. What is Arberg’s variable cost ratio? What is its contribution margin ratio?2. Suppose Arberg’s actual revenues are $30,000 more than budgeted. By how much willoperating income increase? Give the answer without preparing a new income statement.3. How much sales revenue must Arberg earn to break even? Prepare a contribution marginincome statement to verify the accuracy of your answer.4. What is Arberg’s expected margin of safety?5. What is Arberg’s margin of safety if sales revenue is $380,000?
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 ♦ + >
You are given the following information in respect of a company:Budgeted output 50, 000 unitsSelling Price per unit OMR 60Variable Cost per unit OMR 40Total Fixed Costs OMR 20,000Draw a break-even chart showing the breakeven point. If the selling price is reduced to OMR 50 per unit, what will be the new break- even point?
I need answer for requirement 7 and 8 only Statin company expected to sell 3000 masks for $200 each but ended up selling 7500 for $150 each. Their contribution margins are listed below Actual Margin = $500 Standard Margin = $90 .Use the information below to answer following two questions. Statin company adds sanitizer to their product line bringing their total budgeted sales for both products up from 3000 to 4500 and actual sales increased from 7500 to 9000. 7 What is the mixture variance? a.810,000 b.(135,000) c.270,000 d.135,000 8.What is the volume variance? a.810,000 b.135,000 c.270,000 d.405,000
Please do not give solution in image format