Question 6. Juicy Ltd produces and sells Fruit Juices. The company provides the following estimated sales for the next six months: Month January February March April May June Unit Sales 100,000 110,000 120,000 110,000 130,000 120,000 The company's policy is to keep ending inventory of finished goods that is equal to 20% of the unit sales for the next month. Three kilograms of direct materials are required for each bottle of finished goods produced. Each kilogram of direct materials costs $6. Ending inventory levels for materials are equal to 20% of the production needs for the next month. Sales price per bottle is $60. Required (show your workings and round it to the nearest two decimal places): (a) Prepare sales budgets in units and dollars for February and March Prepare production budgets in units for February and March (b) (d) Prepare direct materials purchases budgets in kilograms and dollars for February ANSWER 6: PLACE YOUR ANSWER HERE (PRESS ENTER TO CREATE MORE SPACE) (5 marks) (5 marks) (5 marks)

Entrepreneurial Finance
6th Edition
ISBN:9781337635653
Author:Leach
Publisher:Leach
Chapter4: Preparing And Using Financial Statements
Section: Chapter Questions
Problem 2EP
icon
Related questions
Question
### Question 6

**Juicy Ltd** produces and sells Fruit Juices. The company provides the following estimated sales for the next six months:

| Month     | Unit Sales |
|-----------|------------|
| January   | 100,000    |
| February  | 110,000    |
| March     | 120,000    |
| April     | 110,000    |
| May       | 130,000    |
| June      | 120,000    |

The company’s policy is to keep ending inventory of finished goods that is equal to 20% of the unit sales for the next month. Three kilograms of direct materials are required for each bottle of finished goods produced. Each kilogram of direct materials costs $6. Ending inventory levels for materials are equal to 20% of the production needs for the next month. Sales price per bottle is $60.

**Required** (show your workings and round it to the nearest two decimal places):

(a) Prepare sales budgets in units and dollars for February and March. (5 marks)

(b) Prepare production budgets in units for February and March. (5 marks)

(c) Prepare direct materials purchases budgets in kilograms and dollars for February. (5 marks)

**ANSWER 6:** PLACE YOUR ANSWER HERE (PRESS ENTER TO CREATE MORE SPACE)

---

### Explanation of Diagrams/Tables

**Table Summary:**

- **Table Title:** Estimated Sales for the Next Six Months
- **Columns:**
  - **Month:** List of months from January to June.
  - **Unit Sales:** Projected sales volume for each month.

This table outlines the forecasted unit sales for Juicy Ltd's fruit juice products over the first half of the year. It will serve as the basis for computing various budget components such as sales budgets, production budgets, and direct materials purchases budgets. 

### Instructions:

1. **Sales Budget Calculation:**
  - *Sales in Units* = Projected unit sales for the month.
  - *Sales in Dollars* = Projected unit sales × Sales price per bottle ($60).

2. **Production Budget Calculation:**
  - **For each month, calculate the number of units to be produced using:**
    - Units to be produced = Unit sales for the month + Desired ending inventory - Beginning inventory
    - Desired ending inventory is 20% of the next month’s unit sales.
    - Beginning inventory is the previous month’s ending inventory.
Transcribed Image Text:### Question 6 **Juicy Ltd** produces and sells Fruit Juices. The company provides the following estimated sales for the next six months: | Month | Unit Sales | |-----------|------------| | January | 100,000 | | February | 110,000 | | March | 120,000 | | April | 110,000 | | May | 130,000 | | June | 120,000 | The company’s policy is to keep ending inventory of finished goods that is equal to 20% of the unit sales for the next month. Three kilograms of direct materials are required for each bottle of finished goods produced. Each kilogram of direct materials costs $6. Ending inventory levels for materials are equal to 20% of the production needs for the next month. Sales price per bottle is $60. **Required** (show your workings and round it to the nearest two decimal places): (a) Prepare sales budgets in units and dollars for February and March. (5 marks) (b) Prepare production budgets in units for February and March. (5 marks) (c) Prepare direct materials purchases budgets in kilograms and dollars for February. (5 marks) **ANSWER 6:** PLACE YOUR ANSWER HERE (PRESS ENTER TO CREATE MORE SPACE) --- ### Explanation of Diagrams/Tables **Table Summary:** - **Table Title:** Estimated Sales for the Next Six Months - **Columns:** - **Month:** List of months from January to June. - **Unit Sales:** Projected sales volume for each month. This table outlines the forecasted unit sales for Juicy Ltd's fruit juice products over the first half of the year. It will serve as the basis for computing various budget components such as sales budgets, production budgets, and direct materials purchases budgets. ### Instructions: 1. **Sales Budget Calculation:** - *Sales in Units* = Projected unit sales for the month. - *Sales in Dollars* = Projected unit sales × Sales price per bottle ($60). 2. **Production Budget Calculation:** - **For each month, calculate the number of units to be produced using:** - Units to be produced = Unit sales for the month + Desired ending inventory - Beginning inventory - Desired ending inventory is 20% of the next month’s unit sales. - Beginning inventory is the previous month’s ending inventory.
Expert Solution
steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Financial Reporting in Hyperinflationary Economies
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT