Question
Qaza Inc. sells produces computer mouses and sells them to other stores. The unit sales for the 1st quarter of 2023 were the following: January
Qaza Inc. sells produces computer mouses and sells them to other stores. The unit sales for the 1st quarter of 2023 were the following:
January | February | March |
12,000 | 13,500 | 11,000 |
Qazas CFO is preparing her budget for the 1st quarter of 2024. She predicts that sales will increase by 10% and each mouse will sell for EUR 15.
Sales are received 60% in the month of sale, and 40% in the next month. Sales of December 2023 are expected to be EUR 187,500.
Direct materials cost EUR 8 per unit: 80% is paid in the same month and 20% the following month. Direct materials for December 2023 are expected to be EUR 75,000.
Direct Labor is 50,000 per month, paid in the same month.
Overhead costs are applied at 1.10 per Direct Labor cost (per EUR), they include 20,000 of Depreciation. Payments for overhead are done on the same month.
Qaza Inc. expects to conclude a deal with a bank to receive a 2-year loan of EUR 15,000 on 1st of March 2024. The loan will have a 12% interest rate, paid every end of month (principal is paid at the end of the loan life).
Capital Expenditure (for equipment) payments are due in February 2024 of EUR 25,000.
Closing bank balance in December 2023 is expected to be EUR 10,000.
- Prepare for Qaza Inc. a cash budget in columnar form for the months January through March 2024, showing clearly the opening and closing balances for each month as well for the total quarter.
- Comment on the results. Does Qaza need to change anything?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started