Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June:

While gelato is sold by the cone or cup, the shop measures its activity in terms of the total number of liters of gelato sold. For example, wages should be $7,100 plus $2.90 per liter of gelato sold and the actual wages for June were $24,900. Via Gelato expected to sell 6,000 liters in June, but actually sold 6,200 liters.

Required:

Calculate Via Gelato revenue and spending variances for June. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)

Brady Construction Company contracted to build an apartment complex for a price of $5,700,000. Construction began in 2018 and was completed in 2020. The following is a series of independent situations, numbered 1 through 6, involving differing costs for the project. All costs are stated in thousands of dollars.

Complete the following table. (Do not round intermediate calculations. Enter answers in dollars. Round your final answers to the nearest whole dollar. Negative amounts should be indicated by a minus sign.)

Re-organize the scrambled accounts into the income statement for Pet Land Inc., a pet food and accessories retailer in a small Canadian town.

You will have to calculate Sales Revenue, Cost of Goods Sold, the amount of tax that was paid, the totals for the sections of the statement and determine Gross Margin, Operating Margin, Income Before Tax and Net Income.

Compile Sales Revenue from Gross Sales Revenue and record it on the statement.

Compile the Cost of Goods Sold from the appropriate accounts and add it to the statement. Calculate the Gross Margin and record it on the statement.

List the Operating Expenses on the statement and total it. Calculate the Operating Margin and record it on the statement.

List the Non-operating Expenses on the statement, calculate and record Income Before Tax, calculate and record Taxes and calculate and record Net Income.

At the end of its fiscal year, the adjusted trial balance of Crane Company is as follows:

CRANE COMPANY Adjusted Trial Balance July 31, 2017

Debit Credit Cash $2,850 Accounts receivable 11,420 Prepaid rent 500 Supplies 750 Debt investments 8,000 Equipment 19,950 Accumulated depreciation—equipment $5,700 Patents 18,300 Accounts payable 4,265 Interest payable 750 Unearned revenue 2,050 Notes payable (due on July 1, 2019) 45,300 B. Crane, capital 28,285 B. Crane drawings 16,900 Service revenue 74,100 Interest revenue 320 Depreciation expense 2,850 Interest expense 3,000 Rent expense 18,550 Salaries expense 36,850 Supplies expense 20,850 $160,770 $160,770 Prepare the closing entries. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.) Date Account Titles and Explanation Debit Credit July 31 (To close revenue accounts) July 31 (To close expense accounts) July 31 (To close profit to capital) July 31 (To close drawings account)

Q.1) Emirates Steel Company reported the following accounting values:

Required:

Part 1:

a. Compute contribution margin.

b. Compute contribution margin percentage.

c. Compute gross margin.

d. Compute gross margin percentage.

e. Compute operating income.

Part-2:

Write a note on the above retrieved ratios and give comments whether investment in the shares of M/s Emirates Steel Company is a prudent decision as an investor or not? In both cases, respond why you taken decision of ‘Yes’ or ‘No’ (give reasons)?

Q.2) Pepsi Cola Company wants to estimate the cost for each process. It is a beverage manufacturing unit and only produce different flavors of beverages.

Required:

a. Classify each of the following costs as either direct or indirect with respect to production process.

b. Classify each of the following costs as either fixed or variable with respect to Pepsi Cola Company per day.

1. Take Five Systems, a new start-up, is developing a new iPhone application (“app”) and provides you with the following assumptions: a. Development and testing of the new app will take four months. Month five is the first month of revenue generation. b. Initial monthly app sales of 5,000 downloads at a price of $2.99 c. Unit sales will grow at 15% per month for months six through twelve and then will be flat thereafter d. The app will become obsolete and will need to be revised/replaced after month 18 Use the data provided to forecast Take Five’s monthly revenue for Months 1-18

2. Take Five Systems is concerned about the accuracy of their revenue estimates in Question 1. Specifically, they wish to use sensitivity analysis to evaluate the impact on Month 18 revenue of the following: a. Variations in 2% increments between 9-21% in the growth rate of unit sales in Months 5-12 (that is, 9%, 11%,…, 19%, 21%) b. Variation in 500 unit increments between 2,500 and 7,500 in the level of initial sales (that is, 2,500, 3,000,…, 7,000, 7,500)

could you please show me how to do question 2 on excel? Thank you

The Gourmand Cooking School runs short cooking courses at its small campus. Management has identified two cost drivers it uses in its budgeting and performance reports—the number of courses and the total number of students. For example, the school might run two courses in a month and have a total of 63 students enrolled in those two courses. Data concerning the company’s cost formulas appear below:

For example, administrative expenses should be $3,700 per month plus $46 per course plus $7 per student. The company’s sales should average $850 per student.

The company planned to run four courses with a total of 63 students; however, it actually ran four courses with a total of only 59 students. The actual operating results for September appear below:

Required:

1. Prepare the company’s planning budget for September.

Prepare the company’s planning budget for September.

2. Prepare the company’s flexible budget for September.

Prepare the company’s flexible budget for September.

3. Calculate the revenue and spending

(1) On August 1, 2018, We R Clean Company signed a 9-month contract with a hotel chain to provide pool and spa cleaning services for 3 hotel sites. The contract price of $14,850 was collected on the date the contract was signed. The services will be provided evenly over the next 9 months, starting on August 1. The adjusting entry on December 31, 2018 will

Credit Service Revenue for $6,600

Debit Earned Revenue for $6,600

Credit Service Revenue for 8,910

Debit Unearned Revenue for $8,250

(2) Collegiate Fitness Centers have 15,000 members whose monthly dues are $30 each. The company does not send individual bills to customers, who have until the 10th day of the month following the month of service to pay their monthly dues. On December 31, 2017, the company’s records show that 7,000 customers have already paid their December dues, and the payments were properly recorded. The adjusting entry to be recorded on December 31 will include

Debt Investment Transactions, Available-for-Sale Valuation

Rekya Mart Inc. is a general merchandise retail company that began operations on January 1, Year 1. The following transactions relate to debt investments acquired by Rekya Mart Inc., which has a fiscal year ending on December 31:

Required:

1. Journalize the entries to record these transactions. For a compound transaction, if an amount box does not require an entry, leave it blank.

2. If the bond portfolio is classified as available for sale, what impact would this have on financial statement disclosure?

If the bonds are classified as available-for-sale securities, then the portfolio of bonds would need to be adjusted to fair value . This would be accomplished by using a valuation allowance account and an unrealized gain (loss)  account.

Debt Investment Transactions, Available-for-Sale Valuation

Rekya Mart Inc. is a general merchandise retail company that began operations on January 1, Year 1. The following transactions relate to debt investments acquired by Rekya Mart Inc., which has a fiscal year ending on December 31:

Required:

1. Journalize the entries to record these transactions. For a compound transaction, if an amount box does not require an entry, leave it blank.

2. If the bond portfolio is classified as available for sale, what impact would this have on financial statement disclosure?

If the bonds are classified as available-for-sale securities, then the portfolio of bonds would need to be adjusted to fair value . This would be accomplished by using a valuation allowance account and an unrealized gain (loss)  account.