(ineed new answers)Q5. MN&M Corporation is preparing a budget for 2018. The company provides you with thefollowing details which will help you to prepare the budget: (4 Marks) (Chapter 10, Week 12) Budgeted selling price perunit = SAR 500 per unit Total fixed costs SAR 150,000 Variable costs = SAR 100 per unit Required: You are required=to prepare a flexible budget for 1,000, 1,100, 1,200 and 1,300 units.

Hello student! Flexible Budget is the expected budget for a certain level of activity. Costs and…

Answered: (ineed new answers)Q5. MN&M Corporation…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 3R: Review the completed master budget and answer the following questions: Is Ranger Industries...

See similar textbooks

Similar questions

Styles Abuhatim LLC has given the following particulars. You are required to prepare a cash budget for the three months ending 31st December 2019 Months Sales Materials Wages ( OMR) Over heads (OMR) (OMR) (OMR) August September October 20000 10200 3800 1900 21000 10000 3800 2100 23000 9800 4000 2300 November 25000 10000 4200 2400 December 30000 10800 4500 2500 Credit terms are 1.. Sales /Debtors 10% sales are on Cash, 50% of the credit sales are collected in next month and the balance in the following month 2. Creditors- materials 2 months Wages 1 month -1 month Overheads 3. Cash balance on 1st October is expected to be Ro.8000 4. A machinery will be installed in August at a cost of RO.100000, the monthly instalment of RO.5000 is payable from October onwards 5. Dividend at 10% on preference share capital RO.300,000 will be paid on 1* December 2019 6. Advance to be received for the sale of vehicles RO.20000in December 7. Income tax to be received in December RO.5000
yo template. Part 1- Capital Budgeting (Chapter 6) Questions Please use the following information to answer questions 1-6 Corp makes wooden tables and is creating its 2017 capital budget. It expects to sell 40 tables in 2017 at $150 per table. DM Inventory: BB = 50 b.f. of wood DEI = 75 b.f. of wood your calculations. Feel free to use the example in the notes as a Additional Information for 2017: DM per table: 6 board feet (b.f.) per table at $2.00 per b.f. DL per table: 2 DLH per table at $25 per DLH O/H is applied at a rate of $4 per DLH (and allocated O/H = actual O/H) WIP Inventory BB = 0 EB = 0 FG Inventory BB = 5 tables DEI = 15 tables For simplicity, assume costs and revenue per table are the same for previous years. Assume variable operating expenses are $12 per unit sold and fixed operating expenses are $90. 1) What is budgeted revenue for 2017 in dollars? 2) How many tables (FG units) should be produced in 2017? 3) What is the budgeted O/H cost per unit? octions those…
Imagine the marketing team has an annual budget for 2022 of $500k. Using the table below, create a tracker in excel that communicates to the marketing team, as of the end of Q2 2022, how their actual spend compares to that which has been budgeted. Make up numbers for Q2 2022, and also make up a few examples of commentary that might explain or give context to the spend that is left and/or has been exceeded. Item Annual budget Revisionist History $ 50,000 The Happiness Lab $ 50,000 Deep Cover $ 50,000 Cautionary Tales $ 40,000 Bad Women $ 25,000 A Slight Change of Plans $ 40,000 The Bomber Mafia $ 65,000 Web development $ 100,000 Marketing tech $ 30,000 Social campaign management $ 50,000 total $ 500,000
Howard Cooper, the president of Finch Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 1: Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost. Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 28,000 hours of services in Year 1. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Finch charges customers $57 per hour, the firm can achieve 31,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm…
Q.No. 2 Abuhatim LLC has given the following particulars. You are required to prepare a cash budget for the three months ending 31st December 2019 Months Sales Materials Wages Over heads (OMR) (OMR) (OMR) (OMR) 1900 August 20000 10200 3800 September 21000 10000 3800 2100 October 23000 9800 4000 2300 November 25000 10000 4200 2400 December 30000 10800 4500 2500 Credit terms are 1. Sales /Debtors 10% sales are on Cash , 50% of the credit sales are collected in next month and the balance in the following month 2. Creditors – materials 2 months Wages 1 month Over heads – 1 month 3. Cash balance on 1st October is expected to be Ro.8000 4. A machinery will be installed in August at a cost of RO.100000, the monthly instalment of RO.5000 is payable from October onwards 5. Dividend at 10% on preference share capital RO.300,000 will be paid on 1st December 2019 6. Advance to be received for the sale of vehicles RO.20000in December 7. Income tax tobe received in December RO.5000
Accounting Please solve it ASAP with all requirements Q.7. Toews Ltd has prepared the following flexible budget for the coming year. The Budgeted level of activity is 7,500 units. £ Sales 250,000 Direct material 75,000 Direct labour 60,000 Variable overheads 30,000 Fixed overheads 45,000 Profit 22,500 lf the budget is flexed to a level of activity of 10,000 units, what would the total budgeted cost be? a) £280,000 b) £265,000 c) £123,750 d) £168,750
Case study #3 Hussain Traders LLC is providing the following information. You are required to prepare Cash Budget for the period of 6 months from July to December 2020. All amounts in Rials. Month July August Sales Rent 120,000 6,000 4,000 140,000 7,000 5,000 September 110,000 6,000 7,000 October 130,000 4,000 3,000 November 120,000 6,000 4,000 December 150,000 8,000 5,000 Marketing Expenses Additional information: Salaries 8,000 4,000 5,000 4,000 6,000 7,000 a) Cash sales 50% and the balance in the following month b) Commission received RO 20,000 in the month of November. c) Sale of Fixed Assets in the month of December for RO 5,000 d) Purchase of Printing Machine in September RO 50,000 e) Interest payment to bank RO 40,000 in the month of October f) All other expenses are paid on the 1st of next month. g) Opening Balance for the month of July is RO 50000. Administrative Expenses 1,000 2,000 4,000 3,000 7,000 5,000
Create the six-month budget as shown below for Web Wonders, a new company that provides Internet users with quick and easy access to the World Wide Web. Save the budget as Web Wonders Budget, then answer the following questions. * REVENUE 7 Internet Subscriptions s Homepage Server Space Total Revenue Web Wonders Proposed Six-Month Budget: January to June 2019 [Current Date] 11 EXPENSES $ 12 Salaries 23 Rent 14 Equipment Leases 15 Advertising 16 Operating Costs Total Expenses 39 19 PROFIT NNN www January February March April May June Totals 4500 150 4500 7000 7000 1500 1000 1000 150 G 3500 3500 3500 2500 2500 1200 3500 780 780 780 Bingka 1. In January you estimate that 1000 Internet subscribers will join Web Wonders at a cost of P30 per subscriber. You project that the subscription revenue generated in January will increase 5% in February, 10% in March, then 20% for each of the remaining months. Calculate all increases based on January revenue. What is the total revenue in cell H9? 2.…
The Budget Committee is now ready with the budget estimates for the preparation of the Operating Budget of YAKANG-YAKA Company for the year 2022. The following data were preseted below: Finished Product Model B 8,000 P 140 Model M 5,000 P 170 Budget sales-units Selling price per unit Inventory, Beginning in units Expected inventory end in units 850 600 700 500 Inventory, Beginning in units Expected inventory end in units Material MI 5,000 5,500 Material M2 4,000 5,000 Material M3 3,000 3,600 Model B Model M 4 units 3 units 3 units 15 hours Material Content of each unit: Material M1 Material M2 Material M3 Direct labor hours per unit 6 units 4 units 2 units 10 hours Overhead is applied based on 100% of direct labor hours. Budgeted unit costs: Material M1 Material M2 per unit Material M3 2.50 per unit Direct labor P2.00 Р.00 per uniti 3.00 per hour Other budgeted data based on production are shown below: Factory Overhead: Indirect labor Factory supplies Repairs and maintenance Other…
Part A: Use a spreadsheet to prepare a monthly personal budget to show the available surplus based on the following data. ➤ Monthly salary is QAR 14,600. ➤ Monthly rental expense is QAR 6,650. 19tn3. onidiol ➤ Food expenses are QAR 250 per week. ➤ Electricity is estimated to be QAR 50 per month. ➤ Ooredoo unlimited usage telephone plan is QAR 320 per month. Entertainment is estimated to be QAR 500 per week. ➤Clothing expenses are estimated to be QAR 5,000 per year. Fuel QAR 50 per week. ➤Insurance QAR 2,460 per year. ➤ Vehicle maintenance QAR 2,000 per year. ➤You decide that you must leave a budgeted surplus of QAR 1,000 per month to cover unexpected expenses.
3. What will be the budgeted ‘Salaries’ expenses for 2020 ($)? Note: The Answer field only accepts numbers. Thus, do not include $ or commas when you type your answer. Type your answer as a whole number (e.g., 200000). • Assume you are working on budgeting for the room department of your hotel. • Assume the hotel’s ‘Room Revenue (Sales)’ was $1,640,000 during 2019. Based on the lodging forecast report, you expect the ‘Room Revenue (Sales)’ to increase by 3.7% next year. • Assume the ‘Guest Supplies’ expenses (variable costs) from the room department was $246,000 during 2019. For 2020, this variable cost will remain at the same percentage of the Room Revenue (Sales) as experienced in 2019. • Assume the ‘Salaries’ expenses (fixed costs) from the room department was $280,000 during 2019. For 2020, this fixed cost will increase by 2% due to the expected increase in living expenses in this area.
⦁ MNO Company has projected to sell 500,000 units of its primary product in 2022. It estimates the selling price to be $50 per unit. Required: ⦁ Prepare a Sales Budget for MNO Company in a professional format. Remember the heading, the title and the various columns.

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS