Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

  1. 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.
  2. Comment on the results. Does Qaza need to change anything?

I need a detailed explanation of the solution and a how a table/ tables with results would look like.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions