
a.
Prepare the
a.

Explanation of Solution
Budget:
Budget is an effective tool to achieve the financial and operational goals of the business. Budget is the key element of the financial planning and it assists managers to control the business costs. Management should set the budgeted amount at reasonable and achievable levels.
Prepare the budgeted income statement of Company S for the month May as follows:
Budgeted income statement of Company S for the month of May | |
Particulars | $ |
Budgeted sales | 100,000 |
Less: Cost of goods sold (2) | 60,000 |
Gross profit (1) | 40,000 |
Less: Operating , administrative and selling expense: | |
Variable selling & administrative costs (3) | 5,000 |
Fixed selling & administrative costs | 10,000 |
Budgeted pretax operating income | 25,000 |
Interest expense | 3,000 |
Pretax income | 22,000 |
Less: Income taxes (4) | 5,500 |
Budgeted net income | 16,500 |
Table (1)
Therefore, the budgeted net income of Company S for the month of May is $16,500.
Working note:
Calculate the amount of gross profit
Calculate the cost of goods sold
Calculate the variable selling, and administrative costs
Calculate the income tax expense
b.
Prepare the
b.

Explanation of Solution
Prepare the cash budget of Company S for the month May as follows:
Cash budget of Company S for the month of May | ||
Particulars | $ | $ |
Beginning cash, May 1 | 30,000 | |
Add: | ||
Collections on March sales (5) | 9,000 | |
Collections on April sales (6) | 20,000 | |
Collections on May sales (7) | 40,000 | 69,000 |
Total cash available | 99,000 | |
Less: | ||
Payments on April payables (8) | 6,250 | |
Payments on May payables (9) | 45,000 | |
Variable selling & administrative costs (3) | 5,000 | |
Fixed selling & administrative costs (10) | 7,000 | |
Debt service payments | 4,000 | 67,250 |
Ending cash, May 31 | 31,750 |
Table (2)
Therefore, the ending cash balance at the end of the May is $31,750.
Working note:
Calculate the cash received from the March sales
Calculate the cash received from the April sales
Calculate the cash received from the May sales
Calculate the cash paid for the merchandise purchase for the month April
Note: The purchase in the given month that are paid in the following month is 25%
Calculate the cash paid for the merchandise purchase for the month May
(9)
Calculate the fixed selling and administrative costs
c.
Explain the primary benefits of preparing and using a budget.
c.

Explanation of Solution
Explain the primary benefits of preparing and using a budget as follows:
- Budget indicates the possible problems in the upcoming period, such as insufficient amount of the raw materials or labor needed for the production.
- It ensures the cooperation of different departments within a company to meet the expected production levels.
- Budget can be used at the time when the company sets the financial and operating goals. Company should evaluate the actual performance, and set the budgeted amount at reasonable and achievable levels.
Want to see more full solutions like this?
Chapter 23 Solutions
Financial & Managerial Accounting
- Direct materials used totaled $65,750; direct labor incurred totaled $199,400; manufacturing overhead totaled $344,800; Work in Process Inventory on January 1, 2004, was $186,100; and Work in Process Inventory on December 31, 2004, was $191,600. What is the cost of goods manufactured for the year ended December 31, 2004?arrow_forwardhelp me to solve this questionsarrow_forwardTyson manufacturing company produces and sells 120,000 units of a single product. Variable costs total $340,000 and fixed costs total $480,000. If each unit is sold for $12, what markup percentage is the company using?arrow_forward
- 3 pointsarrow_forwardCrescent Manufacturing produces a single product. Last year, the company had a net operating income of $102,400 using absorption costing and $94,100 using variable costing. The fixed manufacturing overhead cost was $5 per unit. There were no beginning inventories. If 32,000 units were produced last year, then sales last year were_. (a) 21,750 units (b) 29,820 units (c) 30,440 units (d) 35,600 unitsarrow_forwardI don't need ai answer general accounting questionarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education





