ndowHelpnework.pdfAa v100000 38%= 38,000Question 4.Dawn is preparing a budget for her operation. She has forecasted revenue of $1,200,000 for thbudget period and now wants to complete the variable expense portion of her forecast. Dawnreviewed her historical cost percentage records. She then established her target variable costpercentages for several variable cost categories. Use Dawn's target cost percentages to compleher variable expense forecast and then answer the questions that follow.Revenue Forecast: $1,200,000HistoricalVariableExpense CostVariableTarget ExpensePercentageExpensePercentage2.8%ЕxpenseForecastMarketing3.0%36,000Glassware0.250.151,800Paper products0.250,253,000Linens1.00.759,000Flowers anddecorationsKitchen utensils0,500.253,0000.250.253,0001. What is the amount Dawn will budget for marketing?2. What is the amount Dawn will budget for linens?3. What is the amount Dawn will budget for kitchen utensils?4. What would be the impact on marketing costs if Dawn sets that expense at 3 percent ofrevenue and then exceeds her forecasted revenue amount?APR26MacBook Air口

the budgeted statements is prepared for analysis purpose for making decisions

Question 4. Dawn is preparing a budget for her operation. She has forecasted revenue of $1,200,000 for t budget period and now wants to complete the variable expense portion of her forecast. Dawn reviewed her historical cost percentage records. She then established her target variable cost percentages for several variable cost categories. Use Dawn's target cost percentages to comp. her variable expense forecast and then answer the questions that follow. Revenue Forecast: S1,200,000 Varlable Expense Cost Historical Variable Target Expense Percentage Expense Percentage 2.8% Expense Forecast Marketing 3.0% 36,000 Glassware 0.25 0.15 1,800 Paper products 0.25 0.25 3,000 Linens 1.0 0.75 9,000 Flowers and decorations 0.50 0.25 3,000 Kitchen utensils 0.25 0.25 3,000 1. What is the amount Dawn will budget for marketing? 2. What is the amount Dawn will budget for linens? 3. What is the amount Dawn will budget for kitchen utensils? 4. What would be the impact on marketing costs if Dawn sets that expense at 3 percent of revenue and then exceeds her forecasted revenue anmount?

Question 4. Dawn is preparing a budget for her operation. She has forecasted revenue of $1,200,000 for t budget period and now wants to complete the variable expense portion of her forecast. Dawn reviewed her historical cost percentage records. She then established her target variable cost percentages for several variable cost categories. Use Dawn's target cost percentages to comp. her variable expense forecast and then answer the questions that follow. Revenue Forecast: S1,200,000 Varlable Expense Cost Historical Variable Target Expense Percentage Expense Percentage 2.8% Expense Forecast Marketing 3.0% 36,000 Glassware 0.25 0.15 1,800 Paper products 0.25 0.25 3,000 Linens 1.0 0.75 9,000 Flowers and decorations 0.50 0.25 3,000 Kitchen utensils 0.25 0.25 3,000 1. What is the amount Dawn will budget for marketing? 2. What is the amount Dawn will budget for linens? 3. What is the amount Dawn will budget for kitchen utensils? 4. What would be the impact on marketing costs if Dawn sets that expense at 3 percent of revenue and then exceeds her forecasted revenue anmount?

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

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.
On these Excel sheets, you will need to prepare a complete projected income statement in the contribution format for each scenario, in the manner of a flexible budget. The cells will be checked for appropriate formulas, when appropriate. Please highlight the specific answer to the question being posed. Carolina Manufacturing Company has been operating at a loss for several years. A management team has assembled to determine what course of action to take next year to reach profitability. They begin by reviewing the most recent income statement (below). Sales (45,000 units at $15) Less cost of goods sold: Gross margin Less operating expenses Net loss Direct materials Direct labor Manufacturing overhead Carolina Manufacturing Company Income Statement For the Year Ended December 31 Selling expenses Variable Sales commissi Shipping Fixed (advertisi Administrative expenses Variable (billing Fixed (salaries 135,000 117,450 147,750 40,500 8,100 180,000 2,700 72.000 $675,000 400,200 274,800…
Please solve this and explain the solutions
For each situation, select which type of budget you must prepare. Situation You have to assess the likely costs needed to participate in a trade show. A big purchase is required -a new demonstration booth. It will take a lot of time to plan for a trade show, and this is not your only responsibility. You need a plan to ensure that you complete the full range of duties. You are planning an appearance for your company at a trade show. You must forecast the revenue your company may earn as a result of your participation. Financial Operating Nonmonetary
Please creat an Excel spreadsheet with the marketing expenses and revenue data for the previous 10 quartersB.Perform regression analysis to determine the relationship between marketing expenses and revenueC.Using the regression results, creat a graph that plots the data provided along with predicted revenue and 90% confidence interval linesD.Forecast revenue for the next quarter if marketing expenses are budgeted as follows:i.$55,000ii.$65,000iii.$75,000iv.$85,000E.Is this a good representational model? Quantify your answer
Joseph is working on the budget for his summer window-washing business, trying to figure out what his total costs are going to be for the season. He has monthly data from last summer, so he decided to start with that. Using the observations below, use the high-low method to estimate a total monthly cost function for Joseph's business. Month 1 2 3 Number of Labor Hours Spent Y = $ 60 105 85 (Round answers to 2 decimal places, e.g. 15.25.) X + $ Total Cost $196 $322 $250
Journal entry
please help me provide the sales budget for the 4th quarter of 2014, FORMAT: sales budget format for the 4th quarter.
Font Paragraph Styles 6. Assume you are the chief administrator of a small healthcare facility and are comparing the actual cost to the budgeted cost. Prepare a Comparative Analysis of Actual to Budget and write a brief paragraph on how you believe this unit performed during the year. 2021 Actual Difference 2020 Budget Dollars Dollars Dollars Maintenance Expense $300,000.00 $450,000.00 Dietary Expense $615,000.00 $645,000.00 General Services $21,500,000.00 ? $21,200,000.00 ? Supply Expense Total $5,500,000.00 $6,150,000.00
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
Q.How does preparing the budget help Skulas’s management team better manage the company?