Prepare the ending finished goods inventory budget

Reference no: EM131484547

Assignment Question -

Tembisa Ltd produces indoor playground equipment. The company is completing its fifth year of operations and is preparing to build its master budget for the coming year (2017). The master budget will be based on the following information:

(a) The finished goods inventory was 13 000 units at 31 December 2016. Tembisa Ltd is planning the following ending finished goods inventories for each quarter of 2017:

	Quarter 1	Quarter 2	Quarter 3	Quarter 4
Estimated unit finished goods inventory	15 000	20 000	10 000	18 000

(b) Each piece of equipment uses five hours of direct labour and three units of direct materials. Workers are paid $10 per hour, and one unit of direct materials costs $80.

(c) Tembisa plans to have closing inventory of direct materials of 30% of the direct materials needed for next quarter's unit sales.

(d) Fixed overhead totals $1 million each quarter. The fixed overhead rate is computed by dividing the quarter's total fixed overhead by the quarter's budgeted production in units.

(e) Variable overhead is budgeted at $6 per direct labour hour.

(f) The forecast quarterly sales in units for 2017 are as follows:

	Quarter 1	Quarter 2	Quarter 3	Quarter 4
Estimated unit sales	70 000	75 000	90 000	95 000

The selling price is $400 per unit. The fourth-quarter sales for 2016 are 65 000 units.

Assume the following in your answer:

Direct materials inventory and finished goods inventory are costed using the FIFO method.
There is no work-in-progress inventory at any given point in time.

REQUIRED:

A. Design one input and the six output sheets as required in B below. Ensure your spreadsheets meet the "design of spreadsheets" and "formatting" requirements as stated above.

B. Prepare the following five (5) budgets for the first and the second quarter of 2017 and also show the totals for the first half of the year.

1. Sales budget

2. Production budget.

3. Direct material purchases budget.

4. Direct labour budget.

5. Overhead budget.

6. Prepare the ending finished goods inventory budget as at 30 June 2017. Show the unit cost of each component separately using two decimal places.

Attachment:- Assignment File.rar

Reference no: EM131484547

Questions Cloud

How inventory can indeed be reduced by each given actions : How inventory can indeed be reduced by each of the above four actions, with reasoning and examples, in two to four pages. Cite your sources using APA format.

Evaluate the skill acquisition in research methodology : Research Methodology MHH121509 - evaluate the skill acquisition in research methodology techniques, in terms of source and critically review literature.

Which of the following is not one of the four reasons : Based on the Civil Rights Acts of 1866, 1964, and 1991 as well as the 14th Amendment, it is illegal to discriminate against a person based on race.

Discuss the advantages and disadvantages of star : Discuss the advantages and disadvantages of star, bus, and mesh physical topologies. Provide real examples of each type.

Prepare the ending finished goods inventory budget : ACCT19060 T1 2017 Assignment Question. Prepare the ending finished goods inventory budget as at 30 June 2017. Show the unit cost of each component

Explain level of success for the leaders identified : determine if there is a relationship between the level of success for the leaders identified and the incorporation of conscious capitalism by the leaders.

Marketing across digital channels : After reviewing the resources on Dunkin Donuts and its marketing across digital channels. What impact did that have on your relationship with that business?

Dna and rna-genes-mutations and gene therapies : Examine three (3) differences between DNA and RNA then explain two (2) main reasons why DNA is the most favorable molecule for genetic material.

A disadvantage of the? few suppliers sourcing strategy : A disadvantage of the? "few suppliers" sourcing strategy? is:

Reviews

len1484547

5/5/2017 12:59:09 AM

To receive maximum marks for designing the spreadsheets and workbooks, you must adhere to the following requirements: Only have one input sheet which must be the only source for entering all numeric values/data. The purpose of the input sheet is to ensure that you do not type any figures or data in the output sheets (i.e. budgets). The input sheet must only contain raw data. Please do not do your calculations in your input sheet, but link the raw data from your input sheet to the output sheets and use formulae in the output sheets to calculate the figures in each budget. Your output sheets must only contain formulae and links to either the input sheet or previous output sheets if the figure was calculated in a previous budget. Do not type any figures in the cells of your output sheets.

Write a Review

Required(*) Message

User Account

All Pages