1.Budgeted units to be sold for each quarter: 1000, 1200, 1500 and 2000 for the year 2018 and 2019. Assume that company policy requires 20% of the next quarter’s sales in ending inventory and that beginning inventory of t-shirts for the first quarter of the year was 180. The unit selling price of t-shirt is $10.
2. Budgeted units to be produced for each quarter: 1060, 1260, 1600, and 1800. Plain t- shirts cost $3 each, and ink costs $0.20 per ounce. On a per-unit basis, the factory needs one plane t-shirt and five ounces of ink for each logoed t-shirt that the company produces. Lion Inc. is to have 10% of the following quarter’s production needs in ending inventory. The factory has 58 plain t-shirts and 390 ounces of ink on hand on January 1. At the end of the year, the desired ending inventory is 106 plain t- shirts and 530 ounces of ink.
3. Budgeted units to be produced for each quarter are: 1060, 1260, 1600, and 1800. It takes 0.12 hour to produce one t-shirt. The average wage cost per hour is $10.
4. Refer to the direct labor budget. The predetermined overhead rate for variable overhead is $ 5 per direct labor hour. Fixed overhead is budgeted at $1,645 per quarter (this amount include $540 per quarter for depreciation among others). There is no noncash expense items other than depreciation expense.
5. For SG&A expenses: Variable SG&A costs are $0.10 per unit sold. As for fixed SG&A costs, salaries average $1420 per quarter; utilities, $50 per quarter; and depreciation, $150 per quarter. Advertising for quarters 1 through 4 is $100, 200, 800 and 500, respectively. There is no noncash expense items other than depreciation expense. Prepare SG&A Expense Budget.
6. Lion Inc. has provided the following information for preparing a cash budget:
Expected cash balance on 1/1/2018 = $40,000
Information on cash receipts:
(1) From past experience, Lion Inc. expects that, on average, 25%
of total sales are cash and 75% of total sales are on credit. Of
the credit sales, the company expects that 90% will be paid in cash
during the quarter of sale, and the remaining 10% will be paid in
the following quarter. Budgeted units to be sold for each quarter:
1000, 1200, 1500 and 2000.
The balance in A/R as of the last quarter of 2017 was $1350. This
will be collected in cash during the first quarter of 2018.
a. Calculate cash sales expected in each quarter
b. Prepare a schedule showing cash receipts from sales expected in each quarter of 2018.
(2) In the 1st quarter of 2018, Lion Inc. expects to sell marketable securities that are valued at $5,000.
Information on cash disbursements:
(3) Direct materials are all purchased on credit. Lion Inc. usually
pays 80% of its purchases in the same quarter as the purchase and
the rest is paid in the following quarter. The company expects to
have an accounts payable balance of $1,000 on December 31, 2017;
and all outstanding payables are expected to be paid in the first
quarter of 2018. Prepare cash disbursement on A/P budget.
(4) All employees – direct laborers, supervisors, S&A staff –
are all paid in the quarter in which their services are used.
(5) Overhead costs and S&A expenses are paid in the quarter in
which they are incurred.
(6) On April 1, 2018, the company plans to spend $30,000 to buy a
high-end knitting machine, which has a 10-year useful life.
Information on financing:
(7) The company plans to borrow $30,000 from the local bank at an
annual interest rate of 12%
to fund the purchase of the high-end kitting machine at the beginning of the second quarter. Principal will be due in 1 year and interest will be due every quarter. The company does not expect to issue stock or pay any dividends in 2018. Also, as of 12/31/2018, the company does not have any debt on its balance sheet. The company wants to maintain a minimum cash balance of $15,000.
7. Budgeted Income Statement: The Company calculates the
predetermined overhead rate every year using direct labor hours as
a cost driver (Round to the nearest cent). Also, when calculating
the unit product cost, make sure to include two direct material
components (t-shirt and ink).
Put together your master budget for 2018 in the following
order:
1. Sales Budget
2. Schedule of Cash Collection
3. Production Budget
3. Direct materials purchase Budget
- one for T-shirt
- one for Ink
4. Schedule of Cash Disbursement
5. Direct Labor Budget
6. Manufacturing Overhead Budget
7. SG&A Budget
8. Cash Budget
9. Budgeted Income Statement.
In: Accounting
2. Find each of the following articles online and use it to answer the given questions.
a) https://www.forbes.com/sites/rrapier/2017/11/26/fear-will-drive-oil-prices-in-2018/#762158552a1f
I) In the section The Cycle of Fear, is the description of what is happening more consistent with demand or supply shifts? Draw a picture consistent with your answer and explain why the resulting price change in your picture is consistent with the article. (1 point)
II) Do the same as (I) for the section Enter the Shale Boom (1 point)
III) At the end of the article, they predict higher prices in 2018 from two different factors. Draw a diagrams showing why both of these factors (two different shifts) would cause higher oil prices. (1 point)
b) https://www.marketwatch.com/story/netflix-earnings-analysts-await-update-on-how-price-increases-are-affecting-growth-2018-01-17. Note that diagrams may be helpful, but are not required for this question.
I) For the moment, only consider the information through the 7th(?) paragraph (which starts “[That] suggests the service …). If we are looking at the market for NETFLIX subscribers, is this part of the article discussing
i) Demand or Supply?
ii) A shift or a movement along the curve?
Be sure to explain why you come to these conclusions. (1 point)
II) If we go a few paragraphs further (“While Netflix raised prices …) would that change you answer to either (i) or (ii) above? Why?
c) http://abcnews.go.com/Business/story?id=5017914
i) The 3rd paragraph talks about causes of increased food prices in the 70’s. Would all of these causes shift the same curve or different curves? Draw a diagram of the food market consistent with your answer to that question. Be specific about which curve you shifted and why. (1 point)
ii) Four paragraphs later, it lists several reasons for the current increases. This are different than in the 70’s. Does that mean that a different curve is shifting? Draw a diagram and explain.
(1 point)
In: Economics
In: Finance
You are just starting work at a new health department and you have been asked to outline the steps that should be taken to update the department’s preparedness plan for an influenza outbreak. Outline the steps of the report and explain why each is an important component of a preparedness plan.
In: Nursing
Question 3. Issue the following statement to create a copy of the d_clients table named d_clients_copy and write ONE statement to update this table. create table d_clients_copy as select * from d_cliens Change the phone number for Hiram Peters to 5551212 and email to [email protected]
In: Computer Science
You have just been posted to the Office of the Accountant General Expenditure Unit. The Unit is responsible for the consolidation of Government accounts. You have been asked to analyze the information given below in the Trial Balance of the Consolidated Fund for the year ended December 31, 2018.
|
Dr. ($m) |
Cr. ($m) |
|
|
Salaries – Established scale |
6,760 |
|
|
Salaries – Division 1 & 2 |
2,010 |
|
|
Salaries - Division 3 |
230 |
|
|
Administration cost |
3,350 |
|
|
Conferences & seminars |
1,260 |
|
|
Foreign travel |
750 |
|
|
Social benefits |
1,040 |
|
|
Domestic debt interest |
1,450 |
|
|
External debt interest |
1,740 |
|
|
Purchase of vehicles |
250 |
|
|
Purchase of equipment |
410 |
|
|
Construction of infrastructure |
560 |
|
|
Cash and bank |
2,470 |
|
|
PAYE |
7,330 |
|
|
Corporate tax |
5,010 |
|
|
VAT |
2,320 |
|
|
Fines |
150 |
|
|
Fees |
310 |
|
|
Fuel Levy |
700 |
|
|
Grants |
430 |
|
|
Treasury bills |
11,120 |
|
|
Bonds |
13,460 |
|
|
Euro Bond |
7,460 |
|
|
Bilateral & multilateral debt |
19,660 |
|
|
Other expenditure |
910 |
|
|
Accumulated Fund |
44,760 |
|
|
67,950 |
67,950 |
Additional information:
Required:
1. Financial Assets
2. Non – Financial Liabilities
In: Accounting
The annual premium for a $5000 insurance policy against the theft of a painting is $150. If the (empirical) probability that the painting will be stolen during the year is .01, what is your expected return from the insurance company if you take out this insurance and repeat problem from the point of view of the insurance company.
In: Statistics and Probability
Why do you think the empirical studies about factors affecting equity returns basically showed that domestic factors were more important than international factors, and, secondly, that industrial membership of a firm was of little importance in forecasting the international correlation structure of a set of international stocks?
In: Finance
A 12.55 gram sample of an organic compound containing C, H and O is analyzed by combustion analysis and 18.40 grams of CO2 and 7.532 grams of H2O are produced. In a separate experiment, the molar mass is found to be 60.05 g/mol. Determine the empirical formula and the molecular formula of the organic compound.
In: Chemistry
Heights of men on a baseball team have a? bell-shaped distribution with a mean of 175 cm and a standard deviation of 5 cm. Using the empirical? rule, what is the approximate percentage of the men between the following? values? a. 165 cm and 185 cm b. 160 cm and 190 cm
In: Statistics and Probability