Cash (\"Cash\") as of 31 December 20X5 ......... $ 75,000 Unit sales for 20X5 pe
ID: 2771256 • Letter: C
Question
Cash ("Cash") as of 31 December 20X5 ......... $ 75,000
Unit sales for 20X5 per quarter were as follows:
They estimate that by 20x6 sales will be down 10%.
3. All sales are on credit. These 60% are charged the same quarter of generation and 40% in the following quarter. (Note: The sales in the fourth quarter of 20X5 were $ 900,000, 40% of these sales will be collected in the first quarter of 20X6.)
4. The selling price of manufactured product is $ 22.
5. The desired ending inventory for each quarter must be equal to 15% of sales in the next quarter.
6. The management ensures that the initial inventory of direct material of each quarter is 8% of the cost needed for production.
7. The initial inventory of production is 3,000 units. The final inventory in the fourth quarter of 20X6 is projected 6,791unidades.
8. The hours of direct labor are 0.60 per unit, paying $ 8.00 an hour to line employees. The total average hours worked is 480 per quarter.
9. Spending in variable and fixed manufacturing overhead is broken down as follows:
10.
Parts cost $ 5 per unit
Cost per pound $ 0.25
Material 20 pounds ($ 5 / 0.25 = 20) are required
Variable cost per unit:
10.The administrative budget and sales by quarter is presented below:
11. During the first quarter of 20X6 equipment was purchased for $ 30,000.
12. During 20X6 expected to be paid $ 5,000 in dividends in each quarter.
13. The following accounts are projected for 20X6:
Take a MASTER BUDGET showing the four quarters to TVA for 20X6. This should include:
Sales and Cash Receipts Budget (10 pts.)
Production Budget (10 pts.)
Direct Material Purchase Budget (10 pts.)
Direct Labor Budget (10 pts.)
Manufacturing Overhead Budget (10 pts.)
Cash Budget (10 pts.)
Budgeted Income Statement (10 pts.)
Budgeted Balance Sheet (10 pts.)
**** PLEASE INCLUDE ALL THE CALCULATIONS OF THE PROBLEMS***** and all BUDGETED is very important thanks
35,000 37,500 42,200 50,300 Segundo trimestreExplanation / Answer
Sales and Cash Receipts Budget Quarter 1 Primer trimestre Segundo Trimenstre Tercer trimestre Cuarto trimestre Sales in 2015 35,000 37,500 42,200 50,300 Less: Downfall 3,500 3,750 4,220 5,030 Sales in 2016 31,500 33,750 37,980 45,270 Selling Price per unit 22 22 22 22 Sales Revenue 693,000 742,500 835,560 995,940 Total Sales Revenue 3,267,000 Cash Receipts Same quarter Collection 1,960,200 Last Quarter Collection 360,000 Total Cash Receipts 2,320,200 Quarter 2 Primer trimestre Segundo Trimenstre Tercer trimestre Cuarto trimestre Sales in 2015 35,000 37,500 42,200 50,300 Less: Downfall 3,500 3,750 4,220 5,030 Sales in 2016 31,500 33,750 37,980 45,270 Selling Price per unit 22 22 22 22 Sales Revenue 693,000 742,500 835,560 995,940 Total Sales Revenue 3,267,000 Cash Receipts Same quarter Collection 1,960,200 Last Quarter Collection 1,306,800 Total Cash Receipts 3,267,000 Quarter 3 Primer trimestre Segundo Trimenstre Tercer trimestre Cuarto trimestre Sales in 2015 35,000 37,500 42,200 50,300 Less: Downfall 3,500 3,750 4,220 5,030 Sales in 2016 31,500 33,750 37,980 45,270 Selling Price per unit 22 22 22 22 Sales Revenue 693,000 742,500 835,560 995,940 Total Sales Revenue 3,267,000 Cash Receipts Same quarter Collection 1,960,200 Last Quarter Collection 1,306,800 Total Cash Receipts 3,267,000 Quarter 4 Primer trimestre Segundo Trimenstre Tercer trimestre Cuarto trimestre Sales in 2015 35,000 37,500 42,200 50,300 Less: Downfall 3,500 3,750 4,220 5,030 Sales in 2016 31,500 33,750 37,980 45,270 Selling Price per unit 22 22 22 22 Sales Revenue 693,000 742,500 835,560 995,940 Total Sales Revenue 3,267,000 Cash Receipts Same quarter Collection 1,960,200 Last Quarter Collection 1,306,800 Total Cash Receipts 3,267,000 Cash Receipts Budget Quarer 1 Quarer 2 Quarer 3 Quarer 4 Total Cash Receipts 2,320,200 3,267,000 3,267,000 3,267,000