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 -...
-
Dearman Clinics provides medical care in three departments: internal medicine (IM), pediatrics (PD), and obstetrics gynecology (OB). The estimated costs to run each department follow: Dearman expects...
-
Chrome File Edit View History MyPath - Home Bookmarks Profiles Tab Window Help LTI Launch M Question 13 - Ch 12: Assignm Untitled document - Google X +...
-
For the extraction in Example 13-7, suppose we decide to have \(\mathrm{H}_{\text {tank }}=\) \(2 \mathrm{~d}_{\text {tank }}\) and want a 1.5 minute residence time. Find the tank dimensions. Example...
-
Develop your own worksheet for the Butler inventory simulation model shown in Figure. Suppose that management prefers not to charge for loss of goodwill. Run the Butler inventory simulation model...
-
Define: (a) the servicescape for Hudson Jewelers using the three dimensions as subheadings, (b) the nature of Hudson Jewelers' service encounters. Integrative Case: Hudson Jewelers "Good afternoon,...
-
Suppose a person has a utility function given by U = [x + y]1/ where is a number between - and 1. This is called a constant elasticity of substitution (CES) utility function. You will encounter CES...
-
Why do nations that invest more in educating their people tend to have higher economic rates? A ) Educated people tend to be more productive. B ) Educated people tend to return to school. C )...
-
Assuming that the loss is covered, how much would be paid for the following losses under a standard H 0 3 policy with dwelling coverage of $ 5 0 , 0 0 0 ?
-
Direct materials variances The following data relate to the direct materials cost for the production of automobile tires: Actual: 900,000 lbs. at $2.75 per lb. Standard: 916,000 lbs. at $2.70 per lb....
-
The following information is needed to reconcile the cash balance for Gourmet Catering Services. A deposit of $ 5 , 8 0 0 is in transit. Outstanding checks total $ 1 , 1 0 0 . The book balance is $ 6...
-
1. Is it fair for government to levy higher tax rates on the incomes of richer households? Why or why not? 2. What role does discrimination play in determining who is poor and the extent of poverty?...
-
Through digital connectivity, many businesses now compete on in a global market. While the principles of marketing remain the same, strategies and tactics are very dependent on each country. It is...
-
Find an example of an economic announcement having a strong effect on the stock market. Your example need not be from the US, and it need not be current. Explain in one paragraph the nature of the...
-
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...
-
A materials purchases journal, a cash payments journal, and a general journal for Vanyo, Inc., a manufacturer of cardboard boxes, are provided in the Working Papers. Work independently to complete...
-
Work sheets for Bedthings, Inc., a manufacturing firm, are included in the Working Papers. Use the information for April from Work Together 20-2. Work independently to complete the following...
-
Perry, Inc., completed the following factory cost transactions during August of the current year: Instructions: 1. Journalize the transactions. Use page 4 of a materials purchases journal and page 8...
Study smarter with the SolutionInn App