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
Question #2 Cash budgeting is critical to a company’s financial information needs. The following information was extracted from the records of A & B Manufacturing Company Limited. The opening cash balances on January 01, 2021 was expected to be $30,000. The budgeted sales were as follows: Budgeted Sales Month Year $November 2020 80,000December 2020 90,000January 2021 80,000February 2021 75,000March 2021 60,000April 2021 70,000 Analysis of records shows that debtors settle according to the following pattern: 70% within the month of sale 30% the following month Extracts of the purchases budget were as follows:Purchases budget Month Year $December 2020 65,000January 2021 50,000February 2021 75,000March 2021 70,000 …
Solve it sir
Solutions only thank you
SALE, PRODUCTION AND RAW MATERIAL PURCHASES BUDGETS ABC Corporation manufactures and sells two products. Thingone and Thingtwo. In July, 2019, Scarborough’s Budget Department gathered the following data in order to project sales and budget requirements for 2020: 2020 projected sales: Product Units Price Thingone 60,000 Rs. 70 Thingtwo 40,000 Rs. 100 2020 inventories (in units): Product Expected January 1, 2020 Desired December 31, 2020 Thingone 20,000 25,000 Thingtwo 8,000 9,000 To produce one unit of Thingone and Thingtwo, the following raw materials are used: Amount Used per Unit Raw Material Thingone Thingtwo A 4lbs. 5 lbs. B 2lbs 3 lbs. C - 1 unit Projected data for 2020 with respect to raw materials are as follows: Raw Material Anticipated Purchase Price (Rs.) Expected Inventories January 01, 2020 Desired…
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