Prepare a monthly flexible selling expense budget for Podism Company for sales volumes of $270,000, $350,000, and $480,000, based on the following data: Sales commissions 7% of sales Sales manager's salary $62,000 per month Advertising expense $70,000 per month Shipping expense 2% of sales Miscellaneous selling expense $2,500 per month plus 1/2% of sales
Q: Daybreak Technologies Inc. uses flexible budgets that are based on the following data: Sales…
A: Solution: Flexible selling and administrative expense budget is as under:
Q: Flexible Budget for Selling and Administrative Expenses for a Service Company Morningside…
A: Flexible budget is that budget estimates which change with change in level of activity
Q: Flexible Budget for Selling and Administrative Expenses for a Service company Morningside…
A: A flexible budget is that budget which includes all the flexibility and change in the output. In…
Q: the following information is available for Pioneer Company: Sales price per unit is $110.…
A:
Q: X-Tel budgets sales of $60,000 for April, $100,000 for May, and $80,000 for June. In addition, sales…
A: A selling expenses budgeting refers to the selling spending plan which is an arrangement that…
Q: Flexible Budget for Selling and Administrative Expenses for a Service company Daybreak Technologies…
A: Budget means the expected value of future. Budget is not affected by the actual value as it is…
Q: Nafari Company's sales budget has the following unit sales projections for each quarter of Year 4:…
A: Production Budget: Production budget is usually based on the sales budget and the desired inventory…
Q: Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales…
A: The flexible budget is a dynamic budget which can be adjusted according to the changes in volume.…
Q: Flexible Budget for Selling and Administrative Expenses for a Service Company Morningside…
A: A flexible budget is prepared on the basis of the budgeted rate and on the basis of different…
Q: Ronstadt Limited's budget for the four months from January to April includes the following data: 1.…
A: Cash Budget: This is prepared by an entity to forecast the cash available after allocating for the…
Q: Bruins plc’s budget for the first month of trading, during which production of 3,000 units and sales…
A: In the absorption costing Profit = Sales - Variable Cost of Goods Sold - Fixed Cost of Goods Sold…
Q: 1. The following budget estimates are available for Ashton Ltd., manufacturer of a single product:…
A: A cash budget is an important part in accounting as it defines or in simple words it indicates the…
Q: Tempo Company's fixed budget (based on sales of 16,000 units) for the first quarter reveals the…
A: Total Variable Cost :— It means cost which changes with change in units. It depends on Units.…
Q: Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc.…
A: A flexible budget is one in which varying level of expenses are shown when volume of sales changes.…
Q: Prepare a flexible selling and administrative expenses budget for October for sales volumes of…
A:
Q: X-Tel budgets sales of $60,000 for April, $125,000 for May, and $65,000 for June. In addition,…
A: Solution: A budget is an estimation or a financial plan for a defined period, usually one year. It…
Q: Flexible Budget for Selling and Administrative Expenses for a Service Company Daybreak Technologies…
A: 1. Calculation of variable expenses : Total Sales Sales Commission (9% 0f sales ) Advertising…
Q: The following information is available for Pioneer Company: Sales price per unit is $90. November…
A: Computation is represented as below: Thus, total budgeting and administrative expenses for November…
Q: Flexible budget for selling and administrative expenses for a service company Social Media Inc. uses…
A: The selling and administrative expenses budget is prepared to estimate the selling and…
Q: The following information is available for Pioneer Company: Sales price per unit is $100. November…
A: Particulars November December Budgeted Sales unit 3140 3540 Sales price per unit…
Q: Parlee Company's sales are 30% in cash and 70% on credit. 60% of the credit sales are collected in…
A: The budget is prepared by the management on the basis of past experience. On the basis of the…
Q: The following information relates to DGB Corporation: All sales are on account and are budgeted as…
A:
Q: Daybreak Technologies Inc. uses flexible budgets that are based on the following data: Sales…
A: Sales commission = Total sales x 16% Advertising expense = Total sales x 12%
Q: Daybreak Technologies Inc. uses flexible budgets that are based on the following data: Sales…
A: A flexible Budget is a type of budget that adjusts to changes in actual revenue levels. Basically,…
Q: Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions…
A: Budget refers to a statement showing forecast of revenues & expenditures for future period that…
Q: The following information is available for Pioneer Company: Sales price per unit is $90. November…
A: Selling and administrative expenses: Selling and administrative expenses are the expenses incurred…
Q: 1. The following budget information is available for the HD Sales Company (HDC) for January: Sales:…
A: Introduction: A pro forma income statement is a statement showing a company's estimated income after…
Q: LOL CORP. collects 20% of a month's sales in the month of sale, 70% in the month following sale, and…
A: In many cases, companies sell its goods on credit. In such cases, realization of cash from its…
Q: Morningside Technologies Inc. uses flexible budgets that are based on the followWing daa 8% of sales…
A: The selling and administrative expenses are the sum total of all the variable and fixed selling…
Q: The following information is available for Pioneer Company: Sales price per unit is $100. November…
A: Particulars November December Budgeted Sales unit 3140 3540 Sales price per unit $100 $100…
Q: Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions…
A: The flexible budget is a dynamic budget which can be adjusted according to the changes in volume.…
Q: Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc.…
A: Variable expenses are those expenses which changes with change in production or sale volume as the…
Q: Flexible Budget for Selling and Administrative Expenses for a Service company Daybreak Technologies…
A: Under flexible budget, variable cost changes with the volume of sales while the fixed cost remains…
Q: Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions…
A: Here in this question, we are required to prepare flexible budget for different level of sales.…
Q: Fallon Company uses flexible budgets to control its selling expenses. Monthly sales are expected to…
A: Flexible Budget: A flexible budget is a budget that is prepared for different levels of the output.…
Q: еВook Show Me How Print Item Flexible Budget for Selling and Administrative Expenses for a Service…
A: SELLING , GENERAL & ADMINISTRATIVE EXPENSE INCLUDES ALL EVERYDAY OPERATING EXPENSES OF RUNNING A…
Q: Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions Inc.…
A: We know that variable costs changes with the change in the amount of activity and fixed costs remain…
Q: Flexible Budget for Selling and Administrative Expenses for a Service Company Daybreak Technologies…
A: Excel Formula :-
Q: Prepare a monthly flexible selling expenses budget for Stone Company for sales volumes of $300,000,…
A: A flexible budget is prepared on the basis of the budgeted rate and on the basis of different…
Q: (2) Digital Solutions Inc. uses flexible budgets that are based on the following data: Sales…
A: The selling and administrative expenses budget is prepared to estimate the selling expenses during…
Q: Daybreak Technologies Inc. uses flexible budgets that are based on the following data: Sales…
A: Flexible Budget is an important elementary Budget system that help to estimate different income and…
Q: repare a monthly flexible selling expense budget for Podism Company for sales volumes of $270,000,…
A: A selling expense budget is a plan that estimates how much money will be spent selling during the…
Q: The selling and administrative expense budget of Breckinridge Corporation is based on budgeted unit…
A: The question is related to Budgetory Control.The selling and administrative expense budget of…
Q: Flexible Budget for Selling and Administrative Expenses for a Service Company Digital Solutions…
A: Flexible Budget: A flexible budget is a budget that changes with change in volume of production. It…
Q: Warshaw Company budgets payroll at $3,500 per month plus a percentage of monthly sales. The June…
A: The budget is prepared to estimated the requirements of future.
Q: Farm Supply Company's budgeted monthly sales are as follows: April $780,000, May $560,00 and June…
A: The question is related to Budgetary Control. In the given question it is mentioned that one month…
Q: Spana Company has the following data: Total Monthly Purchasing Budget MONTH Budgeted purchases…
A: The schedule of cash disbursements provides the details of cash payments to be made dusting the…
Q: X-Tel budgets sales of $60,000 for April, S100,000 for May, and $80,000 for June. In addition, sales…
A: A selling expense budget is a plan that forecasts the amount of money that will be spent on selling…
Q: Prepare a monthly flexible selling expense budget for Podism Company for sales volumes of $270,000,…
A: Lets understand the basics. Budget is prepared by management to estimate the future profit and loss.…
Q: Sales: 20,000 units quarter 1; 22,000 units quarter 2. Variable costs per dollar of sales:…
A: Selling and administrative budget is a budget which is prepared to estimate the expenses that are to…
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Prepare a monthly flexible selling expense budget for Podism Company for sales volumes of $270,000, $350,000, and $480,000, based on the following data:
Sales commissions | 7% of sales |
Sales manager's salary | $62,000 per month |
Advertising expense | $70,000 per month |
Shipping expense | 2% of sales |
Miscellaneous selling expense | $2,500 per month plus 1/2% of sales |
The variable costs changes with change in production level and fixed cost remains constant at every level of production.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- Relevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,470 $211,539 Direct material purchases 115,290 120,832 Direct labor 75,205 73,299 Manufacturing overhead 25,400 25,400 Selling and administrative expenses 33,400 33,400 Depreciation included in selling and administrative 1,400 1,100 Collections from customers 215,391 240,154 Cash payments for purchases 114,300 119,253 Additional data:Capital assets were sold in January for $9,000 and $4,600 in May.Dividends of $4,400 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $58,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster Company Cash Budget For the First Two Quarters Quarter 1 Quarter 2 Beginning Cash Balance $fill in the blank 2 $fill in the blank 3 Add: Cash Receipts Collections from…Quarter 1 Quarter 2 Sales $248,470 $251,539 Direct material purchases 120,295 128,832 Direct labor 76,553 74,289 Manufacturing overhead 26,000 24,400 Selling and administration expenses 33,500 33,500 Depreciation included in selling and administration expenses 2,000 2,500 Collection from customers 230,524 220,116 Cash payments for purchases 114,345 118,346 Relevant data from Picta Company’s operating budgets are presented below. The company’s financial year ends on 30 June. Additional data: Equipment was sold in July for $8,000 and $4,500 in November. Dividends of $5,500 were paid in August. The beginning cash balance was $80,395 and a required minimum cash balance per quarter is $60,000. The company has a 15% open line of credit for $70 000 with their bank. Required: Use this information to prepare a cash budget for the first two quarters of the year.MCQS: 1) Evergreen Corporation manufactures circuit boards and is in the process of preparing next year's budget. The pro forma income statement for the current year is presented below. Sales $ 3,500,000 Cost of sales: Direct Material $ 500,000 Direct labor 250,000 Variable Overhead 275,000 Fixed Overhead 600,000 1,625,000 Gross Profit $ 1,875,000 Selling and General & Admin. Exp. Variable 750,000 Fixed 250,000 1,000,000 Operating Income $ 875,000 For the coming year, the management of Evergreen Corporation anticipates a 5 percent decrease in sales, a 10 percent increase in all variable costs, and a $45,000 increase in fixed costs. The operating profit for next year would be: A $477,500. B $492,500. C $831,250. D $552,500. 2) Neelon Corporation has two divisions: Southern Division and Northern Division. The following data are for the most recent…
- Oak Tree Villa operates a retail business. Purchases are sold at cost plus 331/3%. Or put another way. purchases are 75% of sales. Budgeted sales K Labour cost K Expenses incurred K January 40,000 3,000 4,000 February 60,000 3,000 6,000 March 160,000 5,000 7,000 April 120,000 4,000 7,000 It is management policy to have sufficient inventory in hand at the end of each month to meet sales demand in the next half month. Payables for materials and expenses are paid in the month after the purchases are made or the expenses incurred. Labour is paid in full by the end of each month. Expenses include a monthly depreciation charge of K2,000. 75% of sales are for cash. 25% of sales are on one month's interest-free credit The company will buy equipment for cash costing K18,000 in February and will pay a dividend of K 20,000 in March. The opening cash balance at 1 February is K1,000. Required (a) Prepare a cash budget for February and March5) Prepare a flexible budget for the SGA expenses at the sales levels provided: Sales commissions 9% of sales Ad expense 12% of sales Miscellaneous expense $5000 per month plus 3% of sales Office expense $20,000 per month Customer support expense $15,000 per month plus 5% of sales R&D expense $30,000 per month $300,000 $500,000 $700,000Professional Fees Earned Budget Day & Spieth, CPAs, offer three types of services to clients: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending March 31, 20Y6: Billable Hours Audit Department: Staff 50,000 Partners 10,000 Tax Department: Staff 75,000 Partners 16,000 Small Business Accounting Department: Staff 20,000 Partners 4,000 The average billing rate for staff is $180 per hour, and the average billing rate for partners is $400 per hour. Prepare a professional fees earned budget for Day & Spieth, CPAs, for the year ending March 31, 20Y6. DAY & SPIETH, CPAs Professional Fees Earned Budget For the Year Ending March 31, 20Y6 Billable Hours Hourly Rate Total Revenue Audit Department: Staff $ $ Partners Total $ Tax Department: Staff $ $ Partners Total…
- SCRUMPTIOUS CUPCAKESProfit and loss accountfor the year ended 30 April 20202020£SalesSales 220,000Cost of sales 120,000Gross Profit 100,000ExpensesSalaries 24,000Other Fixed cost 4,800Distribution 3,000Advertising 4,500Rent 13,200AHUtilities 3,600Other Cost 4,00057,100Operating Profit 42,900 SCRUMPTIOUS CUPCAKESBalance Sheetas at 30 April 20202020£Fixed assetsIntangible assets -Tangible assets 35,000Investments -35,000Current assetsStocks 3,000Debtors 10,000Cash at bank and in hand 6,30019,300Written ReportsCreditors: amounts falling duewithin one year (11,300)Net Current Assets 8,000Total assets less currentliabilities 43,000Net Assets 43,000Capital and reservesCalled up share capital 100Profit and loss account 42,900Shareholders' funds 43,000 please calculate the folliwing ratios: Profitability Ratios – Gross Profit Margin, Net Profit Margin and ROCE● Liquidity – Current Test and Acid Test● Gearing● Activity/Performance – Stock Turnover, Debtors’ Collection Period and AssetTurnover…(M1) Problem: Twitty Company has the following information: Month April May June July $154,000 160,000 142,000 136,000 Budgeted Expenses per Month: Wages Advertising Depreciation Rent Freight-out Other $28,600 27,200 19,000 20,400 freight-out is20% of sales and other expenses are 8% of sales Note: All cash expenses are paid when incurred. The company requires a minimum cash balance of $5,000 to start a month. The beginning cash balance in June is budgeted to be $6,000. Required: 1- Prepare a combined schedule of total operating expenses and cash disbursements for expenses for June. 2- The following additional information has been provided for June: Cash Collections in June ......................................... $130,000 Inventory purchases (all paid in June)................................ $28,000 Dividends paid in June ....................................................... $4,000 Prepare a cash budget in good form for the month of June, using this information and the budgeted…Relevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,480 $211,540 Direct material purchases 115,300 120,832 Direct labor 75,205 73,298 Manufacturing overhead 25,300 25,400 Selling and administrative expenses 33,400 33,500 Depreciation included in selling and administrative 1,500 900 Collections from customers 215,392 240,154 Cash payments for purchases 114,290 119,254 Additional data:Capital assets were sold in January for $10,000 and $4,400 in May.Dividends of $4,600 were paid in February. The beginning cash balance was $60,360 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster CompanyCash BudgetFor the First Two Quarters Quarter 1 Quarter 2 $Beginning Cash Balance $Beginning Cash Balance Add: Cash Receipts Collections from Customers…
- Professional Fees Earned Budget Day & Spieth, CPAs, offer three types of services to clients: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending March 31, 20Y6: Billable Hours Audit Department: Staff 36,000 Partners 5,400 Tax Department: Staff 27,700 Partners 3,500 Small Business Accounting Department: Staff 4,700 Partners 700 The average billing rate for staff is $145 per hour, and the average billing rate for partners is $265 per hour. Prepare a professional fees earned budget for Day & Spieth, CPAs, for the year ending March 31, 20Y6. DAY & SPIETH, CPAs Professional Fees Earned Budget For the Year Ending March 31, 20Y6 Billable Hours Hourly Rate Total Revenue Audit Department: Staff fill in the blank 1 $fill in the blank 2 $fill in the blank 3 Partners fill in the blank 4 fill in the…Relevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,480 $211,540 Direct material purchases 115,295 120,832 Direct labor 75,210 73,298 Manufacturing overhead 25,400 25,400 Selling and administrative expenses 33,600 33,400 Depreciation included in selling and administrative 1,600 900 Collections from customers 215,393 240,156 Cash payments for purchases 114,295 119,254 Additional data:Capital assets were sold in January for $9,000 and $4,500 in May.Dividends of $4,600 were paid in February. The beginning cash balance was $60,359 and a required minimum cash balance is $59,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster CompanyCash BudgetFor the First Two QuarterseBook Print Item Question Content Area Relevant data from the Poster Company’s operating budgets are: Quarter 1 Quarter 2 Sales $208,470 $211,539 Direct material purchases 115,290 120,831 Direct labor 75,200 73,300 Manufacturing overhead 25,400 25,200 Selling and administrative expenses 33,400 33,400 Depreciation included in selling and administrative 1,500 1,100 Collections from customers 215,392 240,154 Cash payments for purchases 114,300 119,252 Additional data:Capital assets were sold in January for $11,000 and $4,500 in May.Dividends of $4,600 were paid in February. The beginning cash balance was $60,360 and a required minimum cash balance is $58,000. Use this information to prepare a cash budget for the first two quarters of the year: If an amount box does not require an entry, leave it blank. The Poster CompanyCash BudgetFor the First Two Quarters Quarter 1 Quarter 2 $- Select - $- Select - Add: Cash Receipts - Select - -…