Construct the S &A expense budgetYear 2 Quarter1234YearBudgeted sales in unitsVariable S&A expense rateTotal variable S&A expensesTotal fixed S&A expensesTotal S&A expensesLess depreciationCash disbursements for S&A expenses??????????100,000100,000100,000100,000400,000?????100,000100,000100,000100,000400,000?? DataYear 2 QuarterYear 3 Quarter123412Budgeted unit sales40,00060,000100,00050,00070,00080,000• Selling price per unit• Accounts receivable, beginning balance• Sales collected in the quarter sales are made• Sales collected in the quarter after sales are made• Desired ending finished goods inventory is• Finished goods inventory, beginning• Raw materials required to produce one unit• Desired ending inventory of raw materials is• Raw materials inventory, beginning• Raw material costs• Raw materials purchases are paidand• Accounts payable for raw materials, beginning balance$12 per unit$65,00075%25%30% of the budgeted unit sales of the next quarter12,000 units5 pounds10% of the next quarter's production needs23,000 pounds$0.80 per pound60% in the quarter the purchases are made40% in the quarter following purchase$81,500•Direct labor cost per hour•Direct labor hour per unit$15 per hour0.2 hour per unit$2 per hour$60,000•Variable MOH rate•Total fixed MOH•Variable S&A expense rate$1.80 per unit$50,00012%•Minimum cash balance•Annual Interest rate

Year 2 1 2 3 4 Year Budgeted Sales in units (A) 40000 60000 100000 50000 250000 Variable…

Construct the S &A expense budget Year 2 Quarter 1 4 Year Budgeted sales in units Variable S&A expense rate Total variable S&A expenses Total fixed S&A expenses Total S&A expenses Less depreciation Cash disbursements for S&A expenses ? ? ? ? ? ? ? ? ? ? ? ? 100,000 100,000 100,000 100,000 400,000 ? ? ? ? ? 100,000 100,000 100,000 100,000 400,000 ? ?

Construct the S &A expense budget Year 2 Quarter 1 4 Year Budgeted sales in units Variable S&A expense rate Total variable S&A expenses Total fixed S&A expenses Total S&A expenses Less depreciation Cash disbursements for S&A expenses ? ? ? ? ? ? ? ? ? ? ? ? 100,000 100,000 100,000 100,000 400,000 ? ? ? ? ? 100,000 100,000 100,000 100,000 400,000 ? ?

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

Budgeting InventoriesFor each independent situation below, determine the missing amounts: A B C D Beginnning inventory 8,000 Answer 5,000 Answer Produced 40,000 25,000 Answer 60,000 Available Answer Answer 26,000 66,000 Sold 45,000 30,000 Answer Answer Ending inventory Answer 10,000 8,000 1,000
Current Attempt in Progress Monty Company combines its operating expenses for budget purposes in a selling and administrative expense budget For the first quarter of 2022, the following data are developed L Sales: 21,500 units unit selling price 2 Variable costs per sales dollar Sales commissions Delivery expense 3 Advertising Fixed costs per quarter Sales salaries Office salaries Depreciation Insurance Utilities $30 Save for Later 6% 4% $24,400 19,500 5,000 2,100 1,000 Prepare a selling and administrative expense budget for the first quarter of 2022 (List variable costs before fixed costs) MONTYCOMPANY Selling and Administrative Expense Budget
Please help me with show all calculation thanku
give detail calculations
Q7 The budgeted sales for the next four quarters are R192 000, R288 000, R288 000 and R336 000 respectively. It is estimated that sales will be paid for as follows:-75% of the total will be paid in the quarter that the sales were made. Of the balance 50% will be paid in the quarter after the sale was made. The remaining 50% will be paid in the quarter after this. The amount of cash received in the third quarter will be: Select one: a. R144 000 b. R240 000 c. R324 000 d. R276 000
Amount Desired at End of Period Length of Time Rate Compounded $ 8,900.00 4 6% Monthly Required: Complete the following using the information above and the present value Table 12.3, the present value table in the Business Math Handbook, or the present value formula to answer the following: Period Used Rate Used PV factor used PV of amount desired at end of period
Budgeting Inventories For each independent situation below, determine the missing amounts: A B D Beginnning inventory 7,000 3,000 Produced 40,000 23,000 60,000 Available 26,000 68,000 Sold 45,000 32,000 Ending inventory 10,000 10,000 3,000
Q45 A company has made the following budget forecasts for next year: R Opening cash balance 1 January 24 000 Net profit from trading for the year 100 000 Payment of tax 25 000 Payment of dividends 20 000 Purchase of new fixed assets 70 000 Annual depreciation charge 22 000 1 January 31 December Stocks R32 000 R35 000 Debtors R41 000 R28 000 Creditors R16 000 R31 000 No other relevant information is available. What is the company's budgeted cash holding at 31 December next year? Select one: a. R56 000 b. R34 000 c. R26 000 d. R6 000
Budgeted Selling and Administrative Expenses Salary Expense Sales Commissions 5% of Sales Insurance Expense Rent Depreciation on equipment Utilities Total Operating Expenses Schedule of Cash Payments for Selling and Administrative Expenses Salary Expense 100% of Prior Month Sales Commissions Insurance Expense October November December Multiple Choice 30,000 30,500 15,000 15,500 12,000 12,000 14,400 14,400 16,500 16,500 2,100 2,300 90,000 91, 200 ? 15,100 12,000 ? 2,200 ? 30,500 ? 12,000 ? ? ? Rent 100% of Prior Months Utilities Expense Total Payments for Selling and Administrative Expenses The amount of cash paid for Selling and Administrative expenses during the month of November is: 31,000 15,300 12,000 14,400 16,500 2,500 91,700 ? ? 12,000 14,400 ?
Break-Even in Sales Revenue, Changes in Variables Carmichael Corporation is in the process of preparing next year's budget. The pro forma income statement for the current year is as follows: Sales $1,800,000 Cost of sales: Direct materials $250,000 Direct labor 180,000 Variable overhead 106,000 Fixed overhead 100,000 636,000 Gross profit $1,164,000 Selling and administrative expenses: Variable $400,000 Fixed 350,000 750,000 Operating income $414,000 Required: 1. What is the break-even sales revenue for Carmichael Corporation for the current year? In your calculations, carry the contribution margin ratio to two decimal places.$937500 2. For the coming year, the management of Carmichael Corporation anticipates an 8 percent increase in variable costs and a $60,000 increase in fixed expenses. What is the break-even point in dollars for next year? In your computation, round the…
Man Hours: Budgeted hours: 40 hours Actual hours used: 44 hours Rate is $28 per hour What is the current and projected budget allotted answer? Project Budget allotted =
Please do not give solution in image format thanku