SBS Company have received a contract to supply its product to a Health Care Service Hospital....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
SBS Company have received a contract to supply its product to a Health Care Service Hospital. The sales involve supplying 1,250 units every quarter, the sales price is RM 85 per unit. The Client intends to pay 80% of the sales within the quarter and the remaining 20% in the next following quarter, and this schedule is not negotiable. Company has no beginning finished product. At the end of the year the desired finished product is 50 units. At the end of every quarter the desired ending inventory is 10% of the next quarter unit sales. Production for each quarter will be based on the unit sales for the quarter. The production will require 5kg of raw materials per unit. The cost of the raw materials is RM 5 per kg. The company has 60kg of beginning raw materials at a cost of RM 5 per kg. The desired ending raw materials is 100kg. SBS will pay 90% of the purchase every quarter. However, this arrangement of payment is negotiable. Production will require 5 direct labour hours per unit of product. The direct labour cost is RM 6 per hour. All wages for the direct labour will be paid within the quarter. The company will incur variable overhead expenses based on direct labour hours. The overhead rate is RM 3 per direct labour hour. The Company will be renting a machine at RM 12,000 per annum. A supervisor will be employed to oversee the production and will be paid RM 15,000 per annum. The rent for the machine and wages of the supervisor will be paid monthly. The monthly administration expenses are as follows:- Salaries Insurance Depreciation Rent of Admin Building 2,000 100 41.67 1,000 The company has a beginning cash balance of RM 5,000. Long term Borrowing can be arranged and will be charged with an 8% interest rate, and the company has to pay 20% of the amount borrowed within the year. Any short-term borrowing will be at 6% interest rate and has to be paid within the year. Required: Prepare a Master Budget for the company until the cash budget. The cash balance at the end of each quarter must show at least RM5,000. SBS Company have received a contract to supply its product to a Health Care Service Hospital. The sales involve supplying 1,250 units every quarter, the sales price is RM 85 per unit. The Client intends to pay 80% of the sales within the quarter and the remaining 20% in the next following quarter, and this schedule is not negotiable. Company has no beginning finished product. At the end of the year the desired finished product is 50 units. At the end of every quarter the desired ending inventory is 10% of the next quarter unit sales. Production for each quarter will be based on the unit sales for the quarter. The production will require 5kg of raw materials per unit. The cost of the raw materials is RM 5 per kg. The company has 60kg of beginning raw materials at a cost of RM 5 per kg. The desired ending raw materials is 100kg. SBS will pay 90% of the purchase every quarter. However, this arrangement of payment is negotiable. Production will require 5 direct labour hours per unit of product. The direct labour cost is RM 6 per hour. All wages for the direct labour will be paid within the quarter. The company will incur variable overhead expenses based on direct labour hours. The overhead rate is RM 3 per direct labour hour. The Company will be renting a machine at RM 12,000 per annum. A supervisor will be employed to oversee the production and will be paid RM 15,000 per annum. The rent for the machine and wages of the supervisor will be paid monthly. The monthly administration expenses are as follows:- Salaries Insurance Depreciation Rent of Admin Building 2,000 100 41.67 1,000 The company has a beginning cash balance of RM 5,000. Long term Borrowing can be arranged and will be charged with an 8% interest rate, and the company has to pay 20% of the amount borrowed within the year. Any short-term borrowing will be at 6% interest rate and has to be paid within the year. Required: Prepare a Master Budget for the company until the cash budget. The cash balance at the end of each quarter must show at least RM5,000.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A chemical company has a contract to supply annually 3600 tonnes of product A at 24 a tonne and 4000 tonnes of product B at 14.50 a tonne. The basic components for these products are obtained from a...
-
A manufacturing company has a contract to supply a customer with parts from April through September. However, the company does not have enough storage space to store the parts during this period, so...
-
1 - The discussion will be based on the following articles. Post at least one discussion point Supplemental Readings include: Stop Hiring Data Scientists until Youre Ready for Data Science by Greta...
-
Question 2 A company manufactures and sells x units of audio system per month. The cost function and the price function (in RM) are given as below. Cost: C(x) = 40,000 + 600 x Price: p(x) = 3,000 -...
-
With a particular grating the sodium doublet is viewed in the third order at 10o to the normal and is barely resolved. Find (a) The grating spacing and (b) The total width of the rulings.
-
Which of the following oxides would you expect to form substitutional solid solutions that have complete (i.e., 100%) solubility with MgO? Explain your answers. (a) FeO (b) BaO (c) PbO (d) CoO
-
An Ontario law permits a game of chance called bingo when it is offered by specific not-for-profit institutions, including churches. Reverend Matthew Pappas, the priest of a new parish in suburban...
-
The following transactions and events affected a Special Revenue Fund of Stem Independent School District during 20X4. 1. The chief accountant discovered that (a) the $20,000 proceeds of a sale of...
-
ack cord: 0/5 Score: 0 Pe David Perez Radical Equations (Le
-
1 Alta Electronics 2 3 4 5 Solution value 6 Selling price per unit 7 Material cost per unit 8 Labor cost per unit 15 9 Profit 10 Constraints 10 Cor 11 Department 1 Dep 12 Department 2 13 Department 3...
-
Donation of land, buildings, and equipment are ______. Multiple select question. reported as temporarily restricted if the donor does not indicate how the asset should be used reported at the donor's...
-
The Minangkabau, a rice-growing society in West Sumatra, Indonesia, is one of the few matrilineal Islamic societies in South Asia. In Minangkabau villages, kinship relations and families are...
-
True or False. The lumped-mass matrices are always diagonal.
-
What are some important connections between kinship and transmigration? Kinship relations are an important factor in the migration of people across state borders-a significant dimension of...
-
How is the distributed load converted into an equivalent joint force vector in the finite element method?
-
Although sese relationships are generally not made public unless they become stable, sese is a culturally regulated custom, the boundaries of which are clearly understood by all. There is no brute...
-
Using the R script, answer the following questions. Suppose you bought AAA stock on January 1st, 2021. You expect to earn 4% return in 2021 and 3% return in 2022. Then, the market value of AAA...
-
Before the 1973 oil embargo and subsequent increases in the price of crude oil, gasoline usage in the United States had grown at a seasonally adjusted rate of 0.57 percent per month, with a standard...
-
The following profit reconciliation statement has been prepared by the management accountant of ABC Limited for March: The standard cost card for the company's only product is as follows: ()...
-
The following information relates to a manufacturing process for a period: 10 000 units of output were produced by the process in the period, of which 420 failed testing and were scrapped. Scrapped...
-
On 30 October the following were among the balances in the cost ledger of a company manufacturing a single product (Product X) in a single process operation: The raw material ledger comprised the...
-
Why is standard deviation preferable to variance?
-
You buy a lottery ticket for BC100 on which you could win BC1,000,000, with a probability rate of 0.008%. Is this a risky investment? Could it be even riskier? How could you reduce the risk? Would...
-
Do shares in Internet companies carry a greater or smaller risk than shares in large retail groups? Why?
Study smarter with the SolutionInn App