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

Molander Corporation is a distributor of a sun umbrella used at resort hotels. Data concerning the next month's budget appear below: Selling price per unit Variable expense per unit Fixed expense per month Unit sales per month $ 28 $ 18 1. Margin of safety (in dollars) 2. Margin of safety percentage $ 9,000 1,050 Required: 1. What is the company's margin of safety? (Do not round intermediate calculations.) 2. What is the company's margin of safety as a percentage of its sales? (Round your percentage answer to 2 decimal places (i.e. 1234 should be entered as 12.34).) %
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 ₱___________.
Please help me with b, c, and d. Thanks!
Molander Corporation is a distributor of a sun umbrella used at resort hotels. Data concerning the next month's budget appear below: Selling price per unit Variable expense per unit Fixed expense per month Unit sales per month $ 1 Margin of safety (in dollars) 2. Margin of safety percentage 27 $ 12 $ 12,300 978 Required: 1. What is the company's margin of safety? (Do not round intermediate calculations.) 2. What is the company's margin of safety as a percentage of its sales? (Round your percentage answer to 2 decimal places (i.e. 1234 should be entered as 12.34).)
Molander Corporation is a distributor of a sun umbrella used at resort hotels. Data concerning the next month's budget appear below: Selling price per unit $ 27 Variable expense per unit $ 18 Fixed expense per month $ 7,650 Unit sales per month 1,000 Required: What is the company's margin of safety in dollars? Note: Do not round intermediate calculations. What is the company's margin of safety as a percentage of its sales? Note: Round your percentage answer to 2 decimal places (i.e. .1234 should be entered as 12.34).
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…
Use attached image to answer the following Required:a. Calculate return on common equity for Year 9 using year-end amounts and assuming no preferred dividends. b. Disaggregate Merck’s ROCE into operating (RNOA) and nonoperating components. Comment on Merck’s use of leverage. (Assume all assets and current liabilities are operating and a 35% tax rate.)
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 ♦ + >
None
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