Forecasting sales:
In the given case, the company is already in the business of designing and manufacturing hard soled and dress shoes. It plans to introduce a new product line of athletic footwear.
Forecast of sales for new product line:
1. Sales volume in general, is a principal budgeting factor. So all other budgets will be linked to this.
2. Other factors such as sales possibilities, production capacity, availability of materials, labor and other inputs should also be studied.
3. Study the existing market conditions of the product that is to be introduced.
4. Determine the market capacity to estimate the no. of units that can be sold.
5. Study the competitors, their quality of product and pricing strategies.
6. Study the investment requirements so that costing can be determined accordingly.
And sales can be forecasted as:
Expected no. of units to be sold | xxx |
× selling price per unit | xx |
Total sales | xxx |
Preparing the Master Budget MANAGERIAL Tom Wills is the majority shareholder and chief executive of...
Master Budget ProjectOkay Company is preparing to build its master budget. The budget will detail each quarter's activity and the activity for the year in total. The master budget will be based on the following information:a. This will be the first year of operation for Okay Company.b. Budgeted unit sales by quarter for 2017 are projected as follows: First quarter 6,300 , Second quarter 6,100 , Third quarter 6,100 & Fourth quarter 6,450 . First and second quarter 2018 budgeted...
Pargo Company is preparing its master budget for 2020. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,000,000 units. Quarterly sales are 18%, 23%, 23%, and 36%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $43 per unit beginning in the fourth quarter. Sales in the first quarter of 2021 are expected to be 10% higher...
Prepare sales and production budgets. A Sheville Company is preparing its master budget for 2022. Relevant data pertaining to its sales and production budgets are as follows. Sales. Sales for the year are expected to total 2,100,000 units. Quarterly sales, as a percentage of total sales, are 15%, 25%, 35%, and 25%, respectively. The sales price is expected to be $70 per unit for the first three quarters and $75 per unit beginning in the fourth quarter. Sales in the...
CALCULATOR PRINTER VERSION BACK NEXT Do It Review 21-2 Pargo Company is preparing its master budget for 2017. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1.400.000 units. Quarterly sales are 184.254.24% and 32% respectively. The sales price is expected to be $40 per unit for the first three quarters and 546 per unit beginning in the fourth quarter Sales in the first quarter of...
LBL Corporation is preparing its master budget for the first quarter of the upcoming year. The following contains detail on LBL’s operations necessary for their master budget: •Sales Information: oActual / Projected Sales are as follows: ♣December (Prior Year; Actual): $75,000 ♣January (Estimated): $85,000 ♣February (Estimated): $91,000 ♣March (Estimated): $96,000 ♣April (Estimated): $112,000 ♣May (Estimated): $120,000 oUnits are sold at $11 each oSales in a month are paid in cash for 40% and on credit for the remainder with credit...
PLEASE HELP! The master budget must be completed using formulas. there must be a sales budget, production budget, Direct Materials budget, Direct labor budget, manufacturing overhead budget, selling and admin budget, budgeted income statement, Schedule of exp collections, sch of exp payments, sch of exp payments DM, cash budget, and budgeted balance sheet. please include the formulas you used. Purpose: The purpose of this project is to help you practice and reinforce the steps necessary to complete a Master Budget,...
Pargo Company is preparing its master budget for 2020. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales. Sales for the year are expected to total 1,700,000 units. Quarterly sales are 18%, 23%, 24%, and 35%, respectively. The sales price is expected to be $41 per unit for the first three quarters and $43 per unit beginning in the fourth quarter. Sales in the first quarter of 2021 are expected to be 15% higher...
Current Attempt in Progress Pargo Company is preparing its master budget for 2020. Relevant data pertaining to its sales, production, and direct materials budgets are as follows. Sales Sales for the year are expected to total 1,900,000 units. Quarterly sales are 22%, 26%, 27% and 25%, respectively. The sales price is expected to be $41 per unit for the first three quarters and $44 per unit beginning in the fourth quarter. Sales in the first quarter of 2021 are expected...
LBL Corporation is preparing its master budget for the first quarter of the upcoming year. The following contains detail on LBL’s operations necessary for their master budget: LBL Corporation is preparing its master budget for the first quarter of the upcoming year. The following contains detail on LBL's operations necessary for their master budget: Sales Information Actual Projected Sales are as follows: December (Prior Year; Actual): $75,000 January (Estimated) $85,000 February (Estimated): $91,000 March (Estimated): $96,000 April (Estimated): $112,000 May...
Part B: Comprehensive Master Budget Allenby's CEO decided to apply the new budget approach in preparing comprehensive budgets for the upcoming second quarter. The following information is assembled from accounting and other business areas. The company sells many styles of earrings, but all are sold for the same price, i.e. $12 per pair. Actual sales of earrings for the last three months and budgeted sales for the next six months follow (in pairs of earrings): January (actual) 22 000 June...