Question

In: Accounting

Sosa Company has provided the following budget information for the first quarter of 2016 Total sales...

Sosa Company has provided the following budget information for the first quarter of 2016 Total sales $297,500 Budgeted purchases of direct materials 39,450 Budgeted direct labor cost 38,880 Budgeted manufacturing overhead costs: Variable manufacturing overhead 3,645 Depreciation 600 Insurance and property taxes 9,120 Budgeted selling and administrative expenses: Salaries expense 5,000 Rent expense 3,000 Insurance expense 1,200 Depreciation expense 100 Supplies expense 2,975 Additional data related to the first quarter of 2016 for Sosa Company: a. Capital expenditures include $36,000 for new manufacturing equipment to be purchased and paid in the first quarter. b. Cash receipts are 60% of sales in the quarter of the sale and 40% in the quarter following the sale. c. Direct materials purchases are paid 70% in the quarter purchased and 30% in the next quarter. d. Direct labor, manufacturing overhead, and selling and administrative costs are paid in the quarter incurred. e. Income tax expense for the first quarter is projected at $42,000 and is paid in the quarter incurred. f. Sosa Company expects to have adequate cash funds and does not anticipate borrowing in the first quarter. g.The December 31,2015,balance in Cash is $14,000, in Accounts Receivable is $23,200, and in Accounts Payable is $10,500. 1.Prepare Sosa Company's schedule of cash receipts from customers and schedule of cash payments for the first quarter of 2016. 2.Prepare Sosa Company's cash budget for the first quarter of 2016.

Solutions

Expert Solution


Related Solutions

Prepare a sales budget for the first quarter (Q1) and the first quarter in total. The...
Prepare a sales budget for the first quarter (Q1) and the first quarter in total. The selling price per unit is $50.00. December 50,000/ January 70,000/February 100,000 /March 60,000 / April 100,000 Past experience shows that 45% of sales are collected in the month of the sale, and 55% in the month following the sale. 2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only sells one product that can...
Prepare a sales budget for the first quarter (Q1) and the first quarter in total. The...
Prepare a sales budget for the first quarter (Q1) and the first quarter in total. The selling price per unit is $50.00. December of the previous year    10,000 January                                     70,000 February                                    30,000 March                                        50,000 April                                          80,000 Past experience shows that 45% of sales are collected in the month of the sale, and 55% in the month following the sale.                           2. Prepare a purchases budget for January through March, and the first quarter in total. Assume that the company only...
The following is the sales budget for Tesoro Azul, Inc., for the first quarter of 2016:...
The following is the sales budget for Tesoro Azul, Inc., for the first quarter of 2016:    January February March Sales budget $142,000 $159,000 $174,000    Credit sales are collected as follows:    70 percent in the month of the sale 25 percent in the month after the sale 5 percent in the second month after the sale    The accounts receivable balance at the end of the previous quarter was $70,150 ($61,200 of which was uncollected December sales).   ...
The following is the sales budget for Tesoro Azul, Inc., for the first quarter of 2016:...
The following is the sales budget for Tesoro Azul, Inc., for the first quarter of 2016:    January February March Sales budget $138,000 $155,000 $170,000    Credit sales are collected as follows:    70 percent in the month of the sale 25 percent in the month after the sale 5 percent in the second month after the sale    The accounts receivable balance at the end of the previous quarter was $68,750 ($60,000 of which was uncollected December sales).   ...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information is available: Total expected sales for last two months of 2019 and four months of 2020 are (in 000’s LE) November December January February March April Sales 200 200 160 160 180 180 All sales are on credit and collections from sales are 60% in the month of sales, 30% in the next month, and 10% in the following month. Cost of goods sold...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information...
“Diamond Company” is preparing a budget for the first quarter of year 2020. The following information is available: Total expected sales for last two months of 2019 and four months of 2020 are (in 000’s LE) November December January February March April Sales 200 200 160 160 180 150 All sales are on credit and collections from sales are 60% in the month of sales, 30% in the next month, and 10% in the following month. Cost of goods sold...
For the first quarter of 2017, do the following. (a) Prepare a sales budget. This is...
For the first quarter of 2017, do the following. (a) Prepare a sales budget. This is similar to Illustration 21-3 on page 1088 of your textbook. (b) Prepare a production budget. This is similar to Illustration 21-5 on page 1089 of your textbook. (c) Prepare a direct materials budget. (Round to nearest dollar) This is similar to Illustration 21-7 on page 1091 of your textbook. (d) Prepare a direct labor budget. (For calculations, round to the nearest hour.) This is...
The following is the sales budget for Profit, Inc., for the first quarter of 2018: January...
The following is the sales budget for Profit, Inc., for the first quarter of 2018: January February March   Sales budget $ 213,000 $ 233,000 $ 256,000 Credit sales are collected as follows: 60 percent in the month of the sale 25 percent in the month after the sale 15 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $97,000 ($67,000 of which was uncollected December sales). a. Calculate the...
Forecast Sales Volume and Sales Budget Raphael Frame Company prepared the following sales budget for 2016:...
Forecast Sales Volume and Sales Budget Raphael Frame Company prepared the following sales budget for 2016: Raphael Frame Company Sales Budget For the Year Ending December 31, 2016 Product and Area Unit Sales Volume Unit Selling Price Total Sales 8" × 10" Frame: East 8,500 $16 $136,000 Central 6,200 16 99,200 West 12,600 16 201,600     Total 27,300 $436,800 12" × 16" Frame: East 3,800 $30 $114,000 Central 3,000 30 90,000 West 5,400 30 162,000     Total 12,200 $366,000 Total revenue from...
Company A is preparing its budget for the third quarter. The following information has been compiled:...
Company A is preparing its budget for the third quarter. The following information has been compiled: Cash collections $50,000 $40,000 $48,000 Cash payments Purchases of inventory 31,000 22,000 18,000 Operating expenses 12,000 9,000 11,600 Capital expenditures 13,000 25,000 0 The cash balance at the end of the second quarter is projected to be $4,000. The company is required to maintain cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT