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)
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)
Chapter4: Preparing And Using Financial Statements
Section: Chapter Questions
Problem 2EP
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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6ea1f414-2cfa-4d12-9b16-9c9fcbba0754%2Fbbc2bf84-700f-4fa9-bf07-5468ba9fc093%2F5onvz19_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
![EBK CFIN](https://www.bartleby.com/isbn_cover_images/9781337671743/9781337671743_smallCoverImage.jpg)
![EBK CFIN](https://www.bartleby.com/isbn_cover_images/9781337671743/9781337671743_smallCoverImage.jpg)