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)

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education