This is a comprehensive problem all contained on this spreadsheet tab.
Cash Budget
Below is summary monthly income statement data for Ace Manufacturing Company.
Sales revenue
Direct materials purchases
Direct labor
Manufacturing overhead
Selling and administrative expenses
January
250,000
60,000
88,000
50,000
45,000
February
275,000
70,000
95,000
52,000
46,000
All sales are on account, and history has shown that 40% of sales is expected to be collected in the month of the sale, with 60%
Direct materials are paid 50% in the month of purchase and 50% the following month. All other expenses are paid as incurred.
costs (depreciation has already been eliminated).
Other data:
1. December sales were $230,000.
2. Purchases of direct materials purchased in December were $50,000.
3. The company has interest payments due of $5,000 per month.
4. The cash balance on January 1 was $15,000.
Instructions
A. Prepare schedules for expected collections from customers and expected payments for direct materials purchases.
B. Prepare a cash budget for January and February.
n the month of the sale, with 60% collected the following month.
er expenses are paid as incurred. All costs shown are cash-based
ect materials purchases.
Why work with us?
Authenticity:
All of our papers are authentic, as each paper of ours is composed according to your unique requirements.
Confidentiality:
We value you data. Our company is extremely efficient in guarding the privacy of our clients.
100% Money Back Guarantee:
In the event you cancel your order, you get your money back as soon as possible, we give a 100% refund.
24/7 Support:
Our team members are available via email, live chat, and phone.
Revision Policy:
You can apply for a revision if you think your paper could be better. In this case, your paper will be revised either by the specialist assigned to you or by another writer.
How the Platform Works
- Click on 'Place Your Order' tab on the menu or click on 'Order Now' tab at the bottom and a new order page will appear
- Fill in your requirements depending on your needs under the 'PAPER DETAILS' area
- In the next section, fill in the academic level, required number of pages, paper deadline as provided in the drop-down menus.
- To enter your registration details, click on 'CREATE ACCOUNT & SIGN IN'. This step allows you to create an account with us for purposes of record-keeping. Click on 'PROCEED TO CHECK OUT' at the bottom of the page
- The next section requires you to fill in the payment details. Follow the guided process and soon your order will be available for our team to work on.