For the year 2016 Fountain springs marketing managers project monthly sales of 520000 1litre and 185000 16litre unit Average selling prices are estimated at 050 per 1litre unit and 700 per 16litre unit prepare a revenue budget for fountain springs inc for the year ending December 31 2016

For the year 2016 Fountain springs marketing managers project monthly sales of 520000 1litre and 185000 16litre unit Average selling prices are estimated at 050 per 1litre unit and 700 per 16litre unit prepare a revenue budget for fountain springs inc for the year ending December 31 2016

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter7: The Master Budget And Flexible Budgeting

Section: Chapter Questions

Problem 5P: Selling and administrative expense budget and budgeted income statement Budgeted selling and...

See similar textbooks

Similar questions

Selling and administrative expense budget and budgeted income statement Budgeted selling and administrative expenses for Scottsdale Styles Inc. in P7-4 for the year ended December 31, 2016, were as follows: Required: 1. Prepare a selling and administrative expenses budget, in good form, for the year 2016. 2. Using the information above and the budgets prepared in P7-4, prepare a budgeted income statement for the year 2016, assuming an income tax rate of 30%.
The Management Accountant of Kafululu Plc has prepared the following budget information for theyear ending 31st December 2022 for product A. Annual Fixed Costs K270,000.00 Variable costs per unit K90.00 Contribution to sales ratio(C/S) 75% Annual budget units 1,500 Required:a) Calculate the contribution per unit for Product A. b) Calculate the Unit Selling Price for Product A. c) Calculate the Break Even Point for Product A. d) Calculate the margin of safety in Units and in percentage terms. e) If the Selling Price per Unit is reduced by 10%, variable cost per Unit is increased to K100.00and Fixed costs remain unchanged, calculate:i. The new Breakeven Point. ii. The total units that should be sold in order to make a profit of K450,000 in 2020.(
Prepare a sales budget. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2019. Palermo Company Sales Budget For the Year Ending December 31, 2019 Description Q1 Q2 Q3 Q4 Year Estimates sales Sales price x unit Sales Revenue
Prepare a sales budget. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2019. Palermo Company Sales Budget For the Year Ending December 31, 2019 Description Q1 Q2 Q3 Q4 Year Estimates sales Sales price x unit Sales Revenue 2. Prepare a production budget for 2 quarters. Sales budget data for Palermo Company are given in exercise 1. Management desires to have an ending finished goods inventory equal to 25% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first 6 months of 2019. Palermo Company Direct Labor Budget For the Six Months Ending June 30, 2019…
The followings are the budget for next financial year (1 January 2023 - 31 December 2023), indicating the average selling price and variable costs of each product category. The common fixed manufacturing overhead and the fixed non-manufacturing overhead costs are estimated to be $1,250,000 and $2,778,320 respectively. Table 1: Budget Jan - Dec 2023 Sales Quantity (in units) In $ Unit selling price Unit production cost Unit selling & admin variable costs (5% of selling price) In $ Revenue Variable Production Costs Selling & Admin Variable Costs Model 1 8,400 600 250 30 Folding Bike Model 2 7,500 400 180 20 Model 3 3,500 480 200 24 Electric Bike 800 2,000 850 100 Total 20,200 5,040,000 3,000,000 1,680,000 1,600,000 11,320,000 (2,100,000)| (1,350,000)| (700,000)| (680,000)| (4,830,000) (252,000) (150,000) (84,000) (80,000) (566,000) Q1. Based on the above budgeted information, calculate the expected breakeven units for the Model 2 folding bikes.
For the quarter ended March 31, 2022, Pharoah Company accumulates the following sales data for its product, Garden-Tools: $341,000 budgeted: $327,000 actual. Prepare a static budget report for the quarter. Product Line Garden- Tools $ Budget PHAROAH COMPANY Sales Budget Report Actual Difference Favourable Unfavourable Neither Favourable nor Unfavourab
Integrated Excel: Preparing a Contribution Format Income Statement Using the High-Low Method Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Budgeted information for Quarter 1 of 2024: Sales in units Sales price per unit After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) Sales Commissions (per dollar of sales). Administrative Salaries (per quarter) Rent Expense (per quarter) Depreciation Expense (per quarter) Shipping has been determined to be a mixed cost with the following total costs and units: 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2023 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Cost $ 67,000 $ 94,000 $ 89,800 $ 92,600 $ 72,500 $80,000 $ 84,000 $ 100,000 17,000 $ 48.00 Units 12,500 21,000 13,800 20,000 13,700 14,000 14,300 22,500 $29.00 9.50€ $ 45,000 $ 27,000 $ 36,000 Required: Use the data to answer the…
The actual selling expenses incurred in March 2020 by Fallon Company are as follows. Variable Expenses Fixed Expenses Sales commissions $11,180 Sales salaries $35,500 Advertising 10,530 Depreciation 7,400 Travel 6,920 Insurance 1,100 Delivery 3,580 (b) Prepare a flexible budget performance report, assuming that March sales were $180,500. (List variable costs before fixed costs.) FALLON COMPANYSelling Expense Flexible Budget ReportFor the Month Ended March 31, 2020 Difference Budget Actual FavorableUnfavorableNeither Favorablenor Unfavorable Select an opening flexible budget report item AdvertisingDepreciationDeliveryFixed ExpensesInsuranceSalesSales CommissionsSales SalariesTotal ExpensesTotal Fixed ExpensesTotal Variable ExpensesTravelVariable Expenses $Enter a dollar amount $Enter a dollar amount Select an opening name for…
Paige Company estimates that unit sales will be 10,000 in quarter 1, 14,000 in quarter 2, 15,000 in quarter 3, and 18,000 in quarter 4. Using a sales price of $70 per unit.Prepare the sales budget by quarters for the year ending December 31, 2020. PAIGE COMPANYSales Budgetchoose the accounting period Quarter 1 2 3 4 Year select an opening name enter a number of units enter a number of units enter a number of units enter a number of units enter a total for the row select an item $enter a dollar amount $enter a dollar amount $enter a dollar amount $enter a dollar amount $enter a dollar amount select a closing name $enter a product of the two previous amounts $enter a product of the two previous…
Please help me with the functions for this ! Thank you! Jay Corporation has decided to prepare contribution income statements for internal planning. Budgeted information for Quarter 1 of 2024: Sales in units 17,000 Sales price per unit $48.00 After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) $29.00 Sales Commissions (per dollar of sales) 9.50% Administrative Salaries (per quarter) $45,000 Rent Expense (per quarter) $27,000 Depreciation Expense (per quarter) $36,000 Shipping has been determined to be a mixed cost with the following total costs and units: 2022 Total Cost Units Quarter 1 $67,000 12,500 Quarter2 $94,000 21,000 Quarter 3 $89,800 13,800 Quarter 4 $92,600 20,000 2023 Quarter 1 $72,500 13,700 Quarter2 $80,000 14,000 Quarter 3 $84,000 14,300 Quarter…
Echo Amplifiers prepared the following sales budget for the first quarter of 2018: Jan. Feb. Mar. Units BOD Sales price $100 $100 Budgeted sales $80,000 $130,000 $100,000 It also has this additional information related to its expenses: Direct material per unit Direct labor per unit Variable manufacturing overhead per hour Fixed manufacturing overhead per month Sales commissions per unit Sales salaries per month Delivery expense per unit Factory utilities per month Administrative salaries per month Marketing expenses per month Insurance expense per month Depreciation expense per month Budgeted Sales in Units Variable Expenses Sales Commissions 1,300 Delivery Total Variable Expenses Fixed Expenses Sales Salaris $100 Administrative Salaries Marketing Expenses Insurance Expense Depreciation Expense 1,500 Total Fixed Expenses Total Selling and Administrative Expenses $1.50 2 Prepare a sales and administrative expense budget for each month in the quarter ending March 31, 2018. Enter all…
Paige Company estimates that unit sales will be 10,000 in quarter 1, 14,000 in quarter 2, 15,000 in quarter 3, and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2017.