Can someone help with this.
The Master Budget
1. Sales Budget
2. Production Budget
Texas Rex sells t-shirts. Expected sales for each quarter is 1000, 1200, 1500, and 2000 t-shirts at $10.00 each. They anticipate no price change.
Texas Rex, Inc.
Sales Budget
For the year ending December 31, 2018
Q1 Q2 Q3 Q4 Total
Units
Unit Selling Price _______ _______ ________ _______ ________
Budgeted Sales
A production budget tells management how many units must be produced to satisfy anticipated sales and ending inventory needs.
Assume the company requires 20% of the next quarter’s sales in ending inventory and that beginning inventory of t-shirts for the first quarter of the year was 180.
Texas Rex, Inc.
Production Budget
For the year ending December 31, 2018
Q1 Q2 Q3 Q4 Total
Sales in Units
Desired Ending Inv. _______ _______ ________ _______ ________
Total Needs
Less Beginning Inv. _______ _______ ________ _______ ________
Units to be Produced
Answer = Part I) | |||||
SALES BUDGET | |||||
1ST QUARTER | 2ND QUARTER | 3RD QUARTER | 4TH QUAERTER | Total | |
Budgeted Sales Units | 1000 | 1200 | 1500 | 2000 | 5700 |
Selling price per unit | $ 10 | $ 10 | $ 10 | $ 10 | $ 10 |
Budgeted Sales | $ 10,000 | $ 12,000 | $ 15,000 | $ 20,000 | $ 57,000 |
Answer = Part II) | |||||
Calculation of Production budget | |||||
1ST QUARTER | 2ND QUARTER | 3RD QUARTER | 4TH QUARTER | Total | |
Units | Units | Units | Units | ||
Production Budget (a) | 1000 | 1200 | 1500 | 2000 | 5700 |
Desired ending inventory(b) | 240 | 300 | 400 | 0 | 940 |
(20% of next months expecting unit Sales) | |||||
Total Needs (a+b) | 1240 | 1500 | 1900 | 2000 | 6640 |
Less: Beginning Inventory | 180 | 240 | 300 | 400 | 1120 |
(Cl of 1st Quart) | (Cl of 2nd Quart) | (Cl of 3rd Quart) | |||
Units to Be Produced | 1060 | 1260 | 1600 | 1600 | 5520 |
Can someone help with this. The Master Budget 1. Sales Budget 2. Production Budget Texas Rex...
Texas Rex sells t-shirts. Expected sales for each quarter is 1000, 1200, 1500, and 2000 t-shirts at $10.00 each. They anticipate no price change. The overhead budget shows forecasted variable and fixed overhead costs for the coming year. For Texas Rex the variable overhead rate is $5 per direct labor hour. Fixed overhead is budgeted at $1645 per quarter. Texas Rex, Inc. Overhead Budget For the year ending December 31, 2018 Q1 Q2 Q3 Q4 Total Budgeted Direct Labor...
Cullumber 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 2,000,000 units. Quarterly sales are 18%, 26%, 23%, and 33%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $45 per unit beginning in the fourth quarter. Sales in the first quarter of 2021 are expected to be 15% higher...
SarasotaCompany 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,200,000 units. Quarterly sales are 18%, 25%, 23%, and 34%, respectively. The sales price is expected to be $38 per unit for the first three quarters and $47 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than...
Question 5 The production budget below pertains to Deera Company. Each unit produced requires 4 feet of raw materials. Each foot of raw materials inventory costs AED 5. Quarter Q1 20:20 Q2 2020 Q3 2020 94 2020 91 2021 Budgeted units of production 20,000 24.000 30,000 2.000 32,000 Ending inventory at the end of each quarter must be equal to 10% of the following quarter's production needs of raw materials. The beginning inventory at the start of the first quarter...
preparing a master budget practice Schedules to include: a. Sales Budget, with a Schedule of Expected Cash Collections b. Production Budget C. Ending Finished Goods Inventory Budget d. Direct Materials Budget, with a Schedule of Cash Disbursement e. Direct Labor Budget f. Manufacturing Overhead Budget g. Selling & Administrative Expense Budget h. Cash Budget i. Budgeted Income Statement Sharp Products is a manufacturing company. It uses absorption costing for budgeting. amount unit Budgeted sales: Q1 of 2019 23,000 cases Q2...
create the initial documents for the master budget: • sales budget • production budget • direct materials purchases budget • direct labor budget • overhead budget • selling and administrative expense budget • cash budget include a schedule of cash collections and payments • finished goods inventory calculation Then, Create the following schedules, financial statements, and calculations A) Pro forma cost of goods manufactured B) Pro forma Cost of goods sold- both financial and variable cost basis C) Pro forma...
Thank you for the help! Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and $12L5. The S12L7 sells for $475, and the S12LS sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows: $12L7 S12LS First quarter, 20Y1 800 1,300 Second quarter, 20Y1 2,200 1,400 Third quarter, 20Y1 s600 5,300 Fourth quarter, 20Y1 4,600 3,900 First quarter, 20Y2 900 1,200 The vice president of sales believes that the projected sales are...
XYZ Corporation is preparing a master budget for 2018. Sales for the year are expected to total 1,000,000 units. Quarterly sales in units are 20%,25%,30%, and 25% respectively. The sales price is expected to be $50 per unit for the first 3 quarters and $55 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than the budgeted sales volume for the first quarter of 2017. Cash collections from sales...
ACC 203-Budgetary Planning Project Fall 2019 DIB corporation’s managerial accountants and the budget committee is meeting in November to prepare the 2019 budget. Your task, as a member of the budget committee, is to prepare the 2019 budget given the following data: Sales: The company expects to sell 40% more units in 2019 than in each quarter of 2018. During 2018, sales were Q1: 40,000; Q2: 30,000; Q3: 60,000 and Q4: 50,000 units. The selling price per unit is expected...
Production Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $475, and the S12L5 sells for $300. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 S12L5 First quarter, 20Y1 800 1,300 Second quarter, 20Y1 2,200 1,400 Third quarter, 20Y1 5,600 5,300 Fourth quarter, 20Y1 4,600 3,900 First quarter, 20Y2 900 1,200 The vice president of sales believes that the projected sales are realistic and can be achieved...