All categories

3 years ago

Learner ID: 6. Explain the reason behind adding borders to cells in a spreadsheet.

Business

1 answer:

Alina [70]3 years ago

7 0

Explanation:

Adding cell borders and filling cells with colors and patterns is an easy way to make your data stand out, appear more organized, and make the spreadsheet easier to read.

You might be interested in

You are evaluating a potential investment in equipment. The equipment's basic price is $176,000, and shipping costs will be $3,5

olga_2 [115]

Answer:

$71,881.45

Explanation:

The after-tax operating cash flow for year 1 is simply the net income plus depreciation for year 1 since depreciation needs to be added back to net income as it is not a cash outflow in the actual sense.

net income=(revenue-annual operating costs-depreciation)*(1-tax rate)

revenue=$151,000

annual operating costs=$77,000

depreciation expense for year 1=($176,000+$3,500+$17,600+$8,800)*33%

depreciation expense for year 1=$67,947.00

tax rate=35.0%

net income=($151,000-$77,000-$67,947)*(1-35%)

net income=$3,934.45

after-tax operating cash flow for year 1=$3,934.45+$67,947.00

after-tax operating cash flow for year 1= $71,881.45

8 0

3 years ago

Given the following production plan, use a chase production strategy to compute the monthly production, ending inventory/(backlo

Goshia [24]

Answer:

Computation of the monthly production, ending inventory/(backlog), net requirements and required workforce levels:

a. The net requirements for January = 2,025 units and 27 workers.

b. The month with the highest number of workers required is April.

c. The production level for June is 2,475 units

d. 27 workers will be employed for the month of January.

Explanation:

a) Data and Calculations:

Production per worker per month = 75 units

Beginning inventory in January = 750 units

Desired ending inventory in June = 750 units

Production Schedule, using the chase production strategy:

Month Jan Feb Mar Apr May Jun

Beginning inventory 75 0 0 0 0 0

Monthly production 2,025 3,000 5,100 6,000 4,800 2,475

Net requirements 2,100 3,000 5,100 6,000 4,800 2,400

Ending inventory/(backlog) 0 0 0 0 0 75

Required workforce levels 27 40 68 80 64 33

6 0

3 years ago

When ursula decides how to price new products in her gift store, she measures the value of her product offerings against those o

KIM [24]

The answer that fits the blank provided is the term COMPETITOR-ORIENTED. Since Ursula is showing that she is aware of the pricing of the other stores within the area, this makes her competitor-oriented. If someone is competitor-oriented, he or she constantly assesses his or herself based on the performance of his or her competitors.

8 0

3 years ago

During 2016, Burr Co. made the following expenditures related to the acquisition of land and the construction of a building:

Colt1911 [192]

Answer:

$64,000 and $358,000

Explanation:

The computation is shown below:

For land:

= Purchase price of land + Legal fees for contracts to purchase land + Demolition of old building on site - Sale of scrap from old building

= $60,000 + $2,000 + $5,000 - $3,000

= $64,000

For building:

= Construction cost of new building (fully completed) + Architects’ fees

= $350,000 + $8,000

=$358,000

8 0

4 years ago

Workplace Products Inc., a wholesaler of office products, was organized on July 1 of the current year, with an authorization of

mash [69]

Answer: Please refer to Explanation

Explanation:

Jul 1

DR Cash (400,000 * 7) $2,800,000

CR Common Stock $2,800,000

(To record common stock issued)

July 1

DR Organisation Expense (1,000*7) $7,000

CR Common Stock $7,000

(To record Common Stock Issue)

Aug 7

DR Land $250,000

DR Building $400,000

DR Equipment $70,000

CR Common Stock $560,000

CR Paid in capital excess of par value - Common stock $160,000

( To record Exchange of common stock for PPE)

Sep 20

DR Cash (25,000 * 44) $1,100,000

CR Preferred Stock (25,000*40) $1,000,000

Paid in Excess Capital of Par Value Preferred Shares $100,000

(To record issue of Preference Shares)

If you need any clarification do comment.

8 0

3 years ago